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

'

Comments ( )
Link to this page: //www.vb-net.com/Sql/Sql/Ts_ca-co_52ua.htm
< THANKS ME>