Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Temp Table in Sql Server
Message
 
 
To
13/11/2014 10:35:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01610894
Message ID:
01610939
Views:
48
>
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform