Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Another temp table question
Message
De
28/09/2012 11:37:19
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Another temp table question
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01553839
Message ID:
01553839
Vues:
66
Hi again

I get that ##temp file is global and can be seen by everyone, but will it stay until it is destroyed?

The Testing application needs to be able to use a subset of the Master file and the best place/time for me to do that is in the Admin application, which is completely separate from the Testing application. The users generally do this the day before and between testing sessions, so what I'd like to do is create a process in the Admin app that will:
Test for ##TestFile existance
if exists
  Drop ##TestFile
  Create new ##TestFile
endif
But if the ##Testfile won't survive past the session that creates it, I need to rethink this.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Répondre
Fil
Voir

Click here to load this message in the networking platform