Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I find out, if database (@DataBaseName) exists?
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00761718
Message ID:
00762210
Vues:
19
>>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. I'll make a comment in SP and would use db_ID then.
The reason, I'm checking, is that I didn't create MACredit database on my local server and want to trap the error.

>>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.

Ok, I just have to find your phone then. :) May be you can e-mail it to me or send in private?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform