A SAVEPOINT statement in SQL identify a point in a transaction to which you can later ROLLBACK.
SAVEPOINT label;
Example 1:
SAVEPOINT savepoint1;
DELETE FROM country WHERE countrycode=34;
ROLLBACK TO SAVEPOINT savepoint1;
A SAVEPOINT statement in SQL identify a point in a transaction to which you can later ROLLBACK.
SAVEPOINT label;
Example 1:
SAVEPOINT savepoint1;
DELETE FROM country WHERE countrycode=34;
ROLLBACK TO SAVEPOINT savepoint1;