ROLLBACK TO SAVEPOINT v10
ROLLBACK TO SAVEPOINT -- roll back to a savepoint.
Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again, if needed.
ROLLBACK TO SAVEPOINT destroys all savepoints that were established after the named savepoint.
The savepoint to which to roll back.
Specifying a savepoint name that has not been established is an error.
ROLLBACK TO SAVEPOINT is not supported within SPL programs.
To undo the effects of the commands executed savepoint
depts was established: