|
Microsoft SQL Server
|
BEGIN [ TRAN [ SACTION ] [ transaction_name | @tran_name_variable ] [ WITH MARK [ 'description' ] ] ]
|
BEGIN TRANSACTION starts an explicit or nested local transaction for the connection issuing the statement. Each transaction continues either until it completes without errors and COMMIT TRANSACTION ends transaction, or if errors are encountered and all modifications are erased with a ROLLBACK TRANSACTION statement.
BEGIN TRANSACTION increments @@TRANCOUNT by 1.
The WITH MARK option is the transaction name which places in the transaction log. When restoring a database to an earlier state, the marked transaction can be used in place of a date and time.
|
