savepoint syntax in sql server code example

Example: savepoint in sql

• SAVEPOINT name —> marks a save point
• COMMIT —> making all pending changes permanent;
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint