Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
syntax error in stored procedure
I'm new to sql and have the following stored procedure but when i check the syntax i keep getting the following error Incorrect syntax near the keyword "begin". Its probably something simple but i just can't see it. create procedure add_policy @policyRef int (4), @fileRef nvarchar (50)...- dinivan
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
inserting problem with trigger
I hope someone will be able to help me with the problem I am having. When the trigger i have attached to my main table is fired it is entering the policyID from the main table into the sub table but it is entering the information entered through the form into a separate row in the sub table...- dinivan
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
sql database - triggers
Hi, I am new to sql databases and was wondering would anybody be able to help me with triggers. I need to write a trigger which is fired when something is entered into the main table, it will then populate the sub table with the primary key from the main table. Any help would greatly be...- dinivan
- Thread
- Replies: 10
- Forum: Microsoft SQL Server: Programming
