Establishes a savepoint within the current transaction.
SAVEPOINT [ savepoint-name ]
The savepoint-name is an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement. All savepoints are automatically released when a transaction ends. See Chapter 1, “Using Procedures and Batches” in the System Administration Guide: Volume 2.
Savepoints that are established while a trigger is executing or while an atomic compound statement is executing are automatically released when the atomic operation ends.
None.
Sybase Not supported in Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, use nested transactions.
None
