santosh asp.net tutorial

The ACID is stands for

1. A--->> Atomicity
2. C-->> Consistency
3. I-->> Isolation
4. D-->> Durability

1. Atomicity:-Atomicity means that all the effects of the transaction must complete successfully or the changes are rolled back. A classic example of an atomic transaction is a withdrawal from an ATM machine; the machine must both dispense the cash and debit your bank account. Either of those actions completing independently would cause a problem for either you or the bank.

2. Consistency:- The consistency requirement ensures that the transaction cannot break the integrity rules of the database; it must leave the database in a consistent state.

3. Isolation:- Isolation refers to keeping the changes of incomplete transactions running at the same time separate from one another. Each transaction must be entirely self-contained, and changes it makes must not be readable by any other transaction

4. Durability:- Once a transaction is committed, it must persist even if there is a system failure — that is, it must be durable. In SQL Server, the information needed to replay changes made in a transaction is written to the transaction log before the transaction is considered to be committed.