Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto Incremental Value in Query
Message
De
06/07/2003 21:16:58
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00807090
Message ID:
00807322
Vues:
24
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform