Use the SAVEPOINT
statement to define a savepoint
; a savepoint is a marker within a transaction. You can use a ROLLBACK
statement to abort the current transaction, returning the state of the server to its condition prior to the specified savepoint. The syntax of a SAVEPOINT
is the database identifier or a host variable that contains the database identifier against which the savepoint resides. If you omit the AT
clause, the statement will execute against the current default database.