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 |
|
SubPar_Coder
Starting Member
23 Posts |
 Posted - 2005-05-10 : 20:02:07
|
| could someone take a look at my sql string please? I get a syntax error that I can't figure out. Code:insert_query = "Create Procedure dbo.Insert_Chart_Assignment( @tmpFirstName varchar(50),@tmpLastName varchar(50),@tmpMidInit char(1),@tmpDOB datetime,@tmpDate datetime)AS SET NOCOUNT ON; INSERT INTO chartassignment(fname, lname, minitial, dob, [date]) VALUES(@tmpFirstName ,@tmpLastName,@tmpMidInit ,@tmpDOB ,@tmpDate,) Select Case SCOPE_IDENTITY()"Jack of all trades, Master of none! |
|
|
SubPar_Coder
Starting Member
23 Posts |
Posted - 2005-05-10 : 20:05:55
|
| I think its erroring out around the VALUES piece.Jack of all trades, Master of none! |
 |
|
|
TypeDef Enum
Starting Member
3 Posts |
Posted - 2005-05-10 : 20:11:01
|
I can see that you have a semi-colon after set nocount on. You have an extra comma after the last variable @tmpDate in your values list. I don't know what you are trying to do with select case scope_identity(). You usually reference this after a row insert and the case keyword is used to change a value eg.select case <column> When 1 then 2 end as <column name>HTHquote:
Originally posted by SubPar_Coder
could someone take a look at my sql string please? I get a syntax error that I can't figure out. Code:insert_query = "Create Procedure dbo.Insert_Chart_Assignment( @tmpFirstName varchar(50),@tmpLastName varchar(50),@tmpMidInit char(1),@tmpDOB datetime,@tmpDate datetime)AS SET NOCOUNT ON; INSERT INTO chartassignment(fname, lname, minitial, dob, [date]) VALUES(@tmpFirstName ,@tmpLastName,@tmpMidInit ,@tmpDOB ,@tmpDate,) Select Case SCOPE_IDENTITY()"Jack of all trades, Master of none!
|
|
|
|
SubPar_Coder
Starting Member
23 Posts |
Posted - 2005-05-10 : 20:26:26
|
| Thanks! I got it to work now.Jack of all trades, Master of none! |
|
|
|
|
|
|
|
|
SQL syntax problem?? {Resolved}