Home

	Expand Search

Reference Manual: Commands

Chapter 1 Commands

begin transaction

begin transaction

Description

Marks the starting point of a user-defined transaction.

Syntax

begin tran[saction] [transaction_name]

Parameters

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

Example 1

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.

Standards

ANSI SQL - Compliance level: Transact-SQL extension.

Permissions

begin transaction permission defaults to all users. No permission is required to use it.

See also

Commands

commit, rollback, save transaction