COMMIT TRANSACTION Statement

Marks the end of a user-defined transaction.

Syntax

COMMIT TRANsaction [transaction_name]

where

transaction_name

Is the name assigned to the transaction. The transaction_name must conform to the rules for identifiers. Use transaction names only on the outermost pair of nested BEGIN... COMMIT or BEGIN...ROLLBACK statements.

Remarks

The ROLLBACK TRANSACTION statement must appear within a transaction. You cannot roll back a transaction after a COMMIT TRANSACTION statement is executed.