Wednesday , January 17 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: