Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto Incremental Value in Query
Message
De
07/07/2003 00:34:10
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:
00807341
Vues:
22
The issue between temporary table vs table variable is the following:

Although both of the two works similarly as the physical table. But there is a big difference between the two in terms of speed. Temporary table need more resources to execute compare to the table variable. That's why if it is possible to use table variable rather than temporary table, just use the table variable for better performance. Sometimes there is a scenario that you cannot use table variable because of the limitation. So temporary table is the only solution. Technically using temporary table and table variable produce the same result except for the performance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform