Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using local temporary tables in selects; good SQL books
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00550435
Message ID:
00551001
Views:
46
DROP TABLE <#TempTableName>

>Is there any way to close local tables generated by a Select without closing the session so that I can keep testing code I'm trying to write in the Query Analyzer? Is there an alternative to putting the Select results into a local table?
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform