Transaction in SQL Server

Transactions:--

In the context of a database, a transaction can be defined as a group of tasks (database operations).

It is a unit of a program execution that accesses and possibly modifies various data objects (database tuples, relations).

A transaction is a logical unit of database processing that includes one or more access operations:

· Read - Retrieval of information from database · Write - insert or update in the database, delete data from the database

ACID (an acronym for Atomicity, Consistency Isolation, Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all these four attributes should be achieved.

Atomicity is an all-or-none proposition.

Consistency guarantees that a transaction never leaves your database in a half-finished state.

Isolation keeps transactions separated from each other until they’re finished.

Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination.