COMMIT and ROLLBACK in SQL Server
COMMIT in SQL Server:
The COMMIT command is used to make changes to a database permanent. If you want to permanently save the modifications you have made to the table(s), use the COMMIT command.
ROLLBACK in SQL Server:
The ROLLBACK command is used to undo all the work the user has done. If you want to undo the changes and want to get the previous values of the tables, use the ROLLBACK command.