What is Transaction in sql server?

Hi  guys,

 This article we will discuss about transaction and properties of transaction in sql server.

Transaction:-

 A transaction is units of work in which all statements are processed successfully or none of the statements are processed.

Properties of Transactions:

Transactions have the following four standard properties, usually referred to by the acronym ACID:

·         Atomicity: ensures that all operations within the work unit are completed successfully; otherwise, the transaction is aborted at the point of failure, and previous operations are rolled back to their former state.

·         Consistency: ensures that the database properly changes states upon a successfully committed transaction.

·         Isolation: enables transactions to operate independently of and transparent to each other.

·         Durability: ensures that the result or effect of a committed transaction persists in case of a system failure.

Transaction Control:

There are following commands used to control transactions:

·         COMMIT: to save the changes.

·         ROLLBACK: to rollback the changes.

·         SAVEPOINT: creates points within groups of transactions in which to ROLLBACK

·         SET TRANSACTION: Places a name on a transaction.

Transactional control commands are only used with the DML commands INSERT, UPDATE and DELETE only. They cannot be used while creating tables or dropping them because these operations are automatically committed in the database.