Rolls back a user-specified transaction to the last savepoint inside the transaction or to the beginning of the transaction.
Transact-SQL Syntax
rollback {tran[saction] | work}
[transaction_name | savepoint_name]
ODBC Syntax
ODBC does not support rollback as a SQL command. ECDA Option for ODBC traps the command and monitors the transaction state with the child process. If a transaction is opened, a call to SQL Transact() is generated.
is the name assigned to the transaction. It must conform to the rules for identifiers.
rollback transaction
The transaction name and savepoint name are ignored. Only one pending transaction is allowed for each connection.
transaction_name is not used with ASE/CIS release 10.5.
The access service strips the transaction_name from the statement before passing it to the target.
