rollback syntax in sql server code example

Example 1: rollback in sql

ROLLBACK;		-- recover datas back to previous commit in current session

Example 2: can we rollback in sql

es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.