Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

Starting Transaction

Some databases allow explicit creation of user-defined transaction by special statements. When such statement database is defined a new user-defined transaction starts.

TABLE 47. Starting Transaction
Database
Syntax
Description
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.
Oracle
Not supported.
 

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.