how to rollback transaction in sql server code example

Example: rollback to name in sql

• ROLLBACK TO name —> rolls back changes to savepoint