Chapter 9 SQL Statements
421
$ For more information on transaction nesting in Adaptive Server
Enterprise and Adaptive Server Anywhere, see "BEGIN TRANSACTION
statement" on page 407. For more information on savepoints, see
"SAVEPOINT statement" on page 600.
You can use a set of options to control the detailed behavior of the COMMIT
statement. For information, see "COOPERATIVE_COMMIT_TIMEOUT
option" on page 181, "COOPERATIVE_COMMITS option" on page 180,
"DELAYED_COMMITS option" on page 184, and
"DELAYED_COMMIT_TIMEOUT option" on page 184. You can use the
Commit connection property to return the number of Commits on the current
connection.
♦
SQL/92 Syntax 1 is an entry-level feature. Syntax 2 is a Transact-SQL
extension.
♦
Sybase Supported by Adaptive Server Enterprise.
♦ The following statement commits the current transaction:
COMMIT
♦ The following Transact-SQL batch reports successive values of
@@trancount
as 0, 1, 2, 1, 0.
PRINT @@trancount
BEGIN TRANSACTION
PRINT @@trancount
BEGIN TRANSACTION
PRINT @@trancount
COMMIT TRANSACTION
PRINT @@trancount
COMMIT TRANSACTION
PRINT @@trancount
go
Standards and
compatibility
Examples
To Next Page
Loading...