sql commit code example

Example 1: commit in sql

COMMIT> making all pending changes permanent;SAVEPOINT name —> marks a save pointROLLBACK> discharges all pending changes to prev commitROLLBACK TO name —> rolls back changes to savepoint

Example 2: commit in sql

COMMIT> making all pending changes permanent;SAVEPOINT name —> marks a save pointROLLBACK> discharges all pending changes to prev commitROLLBACK TO name —> rolls back changes to savepoint

Tags:

Sql Example