Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scrpt questions
Message
De
26/04/2001 14:30:39
 
 
À
26/04/2001 13:38:02
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Divers
Thread ID:
00499152
Message ID:
00500291
Vues:
12
>>Mike, raising that error in QA also 'worked' - in that it prevented the rest of the script from running
>
>Really?!? I tried it but nothing happen
>
>SELECT 'hello'
>RAISERROR ('an error occurred', 16, 127)
>GO
>SELECT 'world'
>GO
>
>This doesn't terminate the script. What did you do?
>
>-Mike

if @cVersion not in ('DB4', 'DB5') raiserror ('DATABASE VERSION ERROR!', 127, 1) with nowait, log

it's ugly - but kills the script

HTH,
Ken B. Matson
GCom2 Solutions
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform