A global variable that holds the error number for the last Transact-SQL statement executed. A value of 0 indicates no error. @@ERROR is reset after each statement is executed, so its value needs to be checked immediately after each Transact-SQL statement. The value must be saved to a local variable if it is to be used later in the code.
A global variable that holds the number of rows returned by the last Transact-SQL statement. @@ROWCOUNT is reset after each statement is executed, so its value should be saved to a local variable if it is needed later in the code.