how to rollback in sql server code example
Example 1: can we rollback in sql
es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.Example 2: rollback to in sql
• ROLLBACK TO name —> rolls back changes to savepointes, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.• ROLLBACK TO name —> rolls back changes to savepoint