Marks the starting point of a user-defined transaction.
begin tran[saction] [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.
Explicitly begins a transaction for the insert statement:
begin transaction
insert into publishers (pub_id) values ("9999")
commit transaction
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.
SQL92 – Compliance level: Transact-SQL extension.
begin transaction permission defaults to all users. No permission is required to use it.
Commands commit, rollback, save transaction
