Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Incremental Value in Query
Message
From
06/07/2003 21:16:58
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00807090
Message ID:
00807322
Views:
22
I guess Mike is refering to the table variable in SQL2000 as the following syntax:
declare @ltables table (nrecno numeric identity(1,1), citemno char(20))


Note this features was first introduce in SQL2000 and much faster execution compare to temporary table. but if you're using version below than SQL2000 you must use the temporary table.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform