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:
00762216
Vues:
17
>>>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.

Seems like overkill to me.

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

It's in my UT profile.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform