begin transaction

Marks the starting point of a user-defined transaction.

Syntax

begin tran[saction] [transaction_name]

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.

Example 1 – 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 system procedures within the phrases begin transaction and commit. If you set chained transaction mode, the SAP ASE 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.

ANSI SQL – Compliance level: Transact-SQL extension.

No permission is required to use begin transaction.