ACID Properties

ACID Stands for Atomicity,Consistency,Isolation and Durability.

Atomicity :Atomicity means that each transaction is treated as all or nothing—it either commits or aborts.If a transaction commits,all its effects remain.If it aborts, all its effects are undone.

Consistency:The consistency property ensures that a transaction won’t allow the system to arrive at an incorrect logical state—the data must always be logically correct.Constraints and rules are honored even in the event of a system failure.

Isolation:Isolation separates simultaneous transactions from the updates of other incomplete transactions.

Durability:After a transaction commits,the durability property of SQL Server ensures that the effects of the transaction preserved even if a system failure occurs.