Commonly used to check the error
status (succeeded or failed) of the most recently executed statement. It
contains 0 if the previous transaction succeeded; otherwise, it
contains the last error number generated by the system.
In the following example, let's assume
that an error will occur during the Update statement. @@error will contain the
error code only until the next statement is executed; even the command for
reading the @@error value will reset it. If it was completed successfully, SQL
Server will set @@error to 0. The only way to preserve the @@error value is to
immediately read it and store it in a local variable; then it can be used for
error handling.
I want to update the sal value on the
EMP table using below sql script
update Emp set sal='Bagesh' where EmpId=1
|
Sal type is int. defiantly it will be
throw error.
See below
Here the value will change of @@ERROR
variable. Now we check the value of @@ERROR
