Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
macca
Posting Yak Master
146 Posts |
 Posted - 2005-10-13 : 07:07:18
|
| I keep getting this error message "Line 15: Incorrect syntax near ')'" in the following stored procedure. Can anyone see anything wrong with it. The table is called licence.maccaCREATE PROCEDURE sproc_AddLicence(@RegNo int,@LicenseeName char(50),@LicenseeAddress char(50),@TelNo varchar(20),@StorageID int)ASBEGININSERT INTO Licence(RegNo,LicenseeName,LicenseeAddress,TelNo,StorageID)VALUES(@RegNo,@LicenseeName,@LicenseeAddress,@TelNo,@StorageID)GO |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-13 : 07:20:14
|
| You forget to use ENDUse END before GoMadhivananFailing to plan is Planning to fail |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-10-13 : 08:33:42
|
| You also do NOT have to use the ( or ) around the parameters at the top. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-13 : 08:51:25
|
quote:
Originally posted by AndrewMurphy
You also do NOT have to use the ( or ) around the parameters at the top.
But there is nothing wrong with that.I see many SQL Programmers use that in order to seperate parameter lists from rest of the coding  MadhivananFailing to plan is Planning to fail |
|
|
|
macca
Posting Yak Master
146 Posts |
Posted - 2005-10-13 : 08:59:30
|
| Thanks for the help Madhivnan.macca |
|
|
|
|
|
|
Error in Stored procedure.