The SAVEPOINT statement is used to set a savepoint within a transaction. You can specify UNIQUE, ON ROLLBACK RETAIN CURSORS, or ON ROLLBACK RETAIN LOCKS.
Create a savepoint called SAVEPOINT1.
SAVEPOINT SAVEPOINT1
For more information, see SAVEPOINT in the SQL Reference topic in the
Information Center.