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 |
|
atlachar123456
Starting Member
33 Posts |
 Posted - 2011-11-23 : 11:53:05
|
| I had created a temp table with id column as identity,its giving error as incorrect syntax near '('CREATE TABLE #temp --11182011_2 ( posid INT IDENTITY(1,1) NULL, position SMALLINT NULL, superId INT NULL )can anyone tell me where is teh error..atlaaaaaaaa |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-23 : 12:43:08
|
| Are you sure you're executing the whole statement - and only the whole statement?I suspect the error is not coming from this.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
atlachar123456
Starting Member
33 Posts |
Posted - 2011-11-23 : 14:04:00
|
| I am not executing only this statemnet,its just a part in my procedurewhen i am executing the entire procedure for me its getting error on this line number incorrect syntax near '('atlaaaaaaaa |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-24 : 03:00:47
|
| Long shot: Make sure that any existing #TEMP is dropped before you create the Sproc (to prevent delayed name resolution fouling up by virtue of #TEMP actually being present)But I don't think that would give you "Syntax Error" |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-24 : 06:12:54
|
| Maybe a missing "end" for a conditional?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Issue with Identity function