Reference Manual
   CHAPTER 9. SQL Statements     

COMMIT TRANSACTION statement [T-SQL]

Function 

To terminate a user-defined transaction or make changes to the database permanent.

Syntax 

COMMIT TRAN[SACTION] [ transaction-name ]

Authorization 

None.

Side effects 

None.

See also 

BEGIN TRANSACTION statement

Description 

The optional parameter transaction-name is the name assigned to this transaction. It must be a valid identifier. You should use transaction names only on the outermost pair of nested BEGIN/COMMIT or BEGIN/ROLLBACK statements.

When executed inside a transaction, the COMMIT TRANSACTION statement decreases the nesting level of transactions by one. When transactions are nested, only the outermost COMMIT makes the changes to the database permanent.

For a discussion of transaction nesting in Adaptive Server Enterprise and Adaptive Server Anywhere, see BEGIN TRANSACTION statement.

Savepoints and the ROLLBACK statement are discussed in SQL Language Elements.

Standards and compatibility 

• SQL/92     Transact-SQL extension.

• Sybase     Supported by Adaptive Server Enterprise.

Example 

• The following Transact-SQL batch reports successive values of @@trancount as 0, 1, 2, 1, 0.

  PRINT @@trancount
  BEGIN TRANSACTION
  PRINT @@trancount
  BEGIN TRANSACTION
  PRINT @@trancount
  COMMIT TRANSACTION
  PRINT @@trancount
  COMMIT TRANSACTION
  PRINT @@trancount
  go