Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Raise an exception from within a SP
Message
From
08/12/2005 13:04:15
Fabio Lunardon
Lunacom
Marostica, Italy
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: Raise an exception from within a SP
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01076224
Message ID:
01076278
Views:
28
>Not really.
>value in @@Error changes after the execution of each statement. So if the first statement returned and error, and the last one returned ok, then @@error is ok. So after each statement you need to check @@error and copy its value into your own var.

Now you known because i doesn't suggest this.
On SQL 2005 TRY/CATCH fixes this
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform