Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check for existence of #TempTable?
Message
From
08/05/2006 05:14:00
 
 
To
08/05/2006 04:57:43
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01119975
Message ID:
01119979
Views:
16
Thank's Jon.

All this #Temp stuff is on the connection level, right?

Two users with different (not shared) connections could both have a #Temp table containing different data at the same time?

What happens if it's a shared connection?


>IF Object_Id('tempdb..#tempas') IS Not Null
>
>>Well, that's pretty much it!
>>
>>Thank's in advance.
>>
>>BR
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform