TRANSACTIONS CONTROL LANGUAGE (TCL):
Transaction is nothing but a unit of work.
We can control these transactions using the following statements
- ROLLBACK Statement
- COMMIT Statement
- SAVE TRAN [SACTION]
1.ROLLBACK Statement: ROLLBACK statement is used to cancel a particular performed transaction.
2. COMMIT Statement: COMMIT statement makes a transaction permanent. It is not possible to rollback the committed transaction.
3. SAVE TRAN Statement: SAVE TRAN statement is used to COMMIT/ROLLBACK a particular performed transaction from the set of transactions.