SQL SERVER -- TCL Commands-- Part-7

TCL Commands:-
                                                            TCL Stands for Transaction Control Language.                Following are the TCL Commands.
                                                 1. COMMIT
                                                 2. ROLLBACK

COMMIT – COMMIT is used to Save the Work done by Previous Transactions.

-- COMMIT

BEGIN TRANSACTION

DELETE FROM EMP

COMMIT TRANSACTION

ROLLBACK – ROLLBACK is used to UnSave the work done by                                                Previous Transactions.

-- ROLLBACK

BEGIN TRANSACTION

DELETE FROM EMP

ROLLBACK TRANSACTION