begin transaction

Description
            Marks the starting point of a user-defined transaction.
Syntax
            begin tran[saction] [transaction_name]
Parameters
            transaction_name
               is the name assigned to this transaction. Transaction names must conform to
               the rules for identifiers. Use transaction names only on the outermost pair of
               nested begin transaction/commit or begin transaction/rollback statements.
Examples
            Explicitly begins a transaction for the insert statement:

                 begin transaction
                       insert into publishers (pub_id) values ("9999")
                 commit transaction
Usage
            •    Define a transaction by enclosing SQL statements and/or system
                 procedures within the phrases begin transaction and commit. If you set
                 chained transaction mode, Adaptive Server implicitly invokes a begin
                 transaction before the following statements: delete, insert, open, fetch,
                 select, and update. You must still explicitly close the transaction with a
                 commit.
            •    To cancel all or part of a transaction, use the rollback command. The
                 rollback command must appear within a transaction; you cannot roll back
                 a transaction after it is committed.