Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I find out, if database (@DataBaseName) exists?
Message
De
06/03/2003 10:57:16
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00761718
Message ID:
00762203
Vues:
21
>
>Anyway, the original question remains: which method is better. They both accomplish the same, I assume, that db_id may be executing the same query, as you gave me, but internally. What should I use or there is no difference?

The information_schema method suppouse to work for any backend that is ANSII compliant. DB_ID as Sql Server specific may be faster. Make your choice and stick with it. BTW, why do you need to check for existence of everything?

>
>Thanks to you and Bob for the Help.
>
>May I call you, I have a quite urgent question and don't know, what keyword is correct to make a search?

Yes.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform