Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I check for existence of #TempTable?
Message
De
08/05/2006 05:14:00
 
 
À
08/05/2006 04:57:43
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01119975
Message ID:
01119979
Vues:
15
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform