Monday , December 10 2018
Home / DataBase / SQL SERVER / TRANSACTIONS CONTROL LANGUAGE(TCL) In Sql Server:

TRANSACTIONS CONTROL LANGUAGE(TCL) In Sql Server:

TRANSACTIONS CONTROL LANGUAGE (TCL): 

Transaction is nothing but a unit of work.

We can control these transactions using the following statements

  1. ROLLBACK Statement
  2. COMMIT Statement
  3. 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.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …