Transact-SQL Reference

COMMIT WORK

Marks the end of a transaction.

Syntax

COMMIT [ WORK ]

Remarks

This statement functions identically to COMMIT TRANSACTION, except COMMIT TRANSACTION accepts a user-defined transaction name. This COMMIT syntax, with or without specifying the optional keyword WORK, is compatible with SQL-92.

See Also

BEGIN DISTRIBUTED TRANSACTION

BEGIN TRANSACTION

COMMIT TRANSACTION

ROLLBACK TRANSACTION

ROLLBACK WORK

SAVE TRANSACTION

@@TRANCOUNT