Thursday, June 05, 2014

@@ERROR (Transact-SQL)

@@ERROR (Transact-SQL) Returns the error number for the last Transact-SQL statement executed.

Returns 0 if the previous Transact-SQL statement encountered no errors.
Returns an error number if the previous statement encountered an error. If the error was one
of the errors in the sys.messages catalog view, then @@ERROR contains the value from the
sys.messages.message_id column for that error. You can view the text associated with an
@@ERROR error number in sys.messages.
Because @@ERROR is cleared and reset on each statement executed, check it immediately
following the statement being verified, or save it to a local variable that can be checked later.
Use the TRY...CATCH construct to handle errors. The TRY...CATCH construct also supports
additional system functions (ERROR_LINE, ERROR_MESSAGE, ERROR_PROCEDURE,
ERROR_SEVERITY, and ERROR_STATE) that return more error information than @@ERROR.
TRY...CATCH also supports an ERROR_NUMBER function that is not limited to returning the
error number in the statement immediately after the statement that generated an error.

No comments:

Post a Comment