Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create Temp Table in Sql Server
Message
 
 
À
13/11/2014 10:35:15
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01610894
Message ID:
01610939
Vues:
47
>
>The ## prefixed tables stay for the duration of your handle; the # prefixed stay for the duration of your current batch, which is a tad harder to define - generally, when you need them again, you need to create them again; when your batch failed and you run it again, they are still there and you have to drop them first.
>
< snip >

Global (##) tables are visible to to any user and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform