BEGIN TRANSACTION Statement

Marks the starting point of a user-specified transaction.

Syntax

BEGIN 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

Naming multiple transactions with a transaction_name has little effect on the transaction. Only the first (outermost) transaction name is registered with the system. A rollback to any other name (other than a valid savepoint_name) generates an error. None of the statements executed before the rollback are in fact rolled back when this error occurs.