Transactions and Global Variables

Some global variables provide information to use in transactions.

• Check for Errors with @@error
  The @@error global variable is commonly used to check the error status of the most recently executed batch in the current user session. @@error contains 0 if the last transaction succeeded; otherwise, @@error contains the last error number generated by the system.
• Check IDENTITY Values with @@identity
  @@identity contains the last value inserted into an IDENTITY column in the current user session.
• Check the Transaction Nesting Level with @@trancount
  @@trancount contains the nesting level of transactions in the current user session.
• Check the Transaction State with @@transtate
  @@transtate contains the current state of a transaction after a statement executes in the current user session. Unlike @@error, @@transtate is not cleared for each batch.
• Check the Nesting Level with @@nestlevel
  @@nestlevel contains the nesting level of current execution with the user session, initially 0.
• Check the Status From the Last Fetch
  @@sqlstatus contains status information resulting from the last fetch statement for the current user session.