SQL SERVER - ACID Rules (Atomicity, Consistency, Isolation, Durability)

ACID property that is Atomicity, Consistancy, Isolation, Durability

Atomicity means the transaction must be executed all or none. Here partial execution of transaction must not be done.The transfer of funds can be completed or it can fail for a multitude of reasons, but atomicity guarantees that one account won't be debited if the other is not credited as well.

Consistency ensures that the database is stable, before and after the transaction, even if a transaction fails. the output must be consistent, i.e transaction never leaves your database in a half-finished state.

Isolation means multiple transactions occurring at the same time will not impact each other’s execution.  The transaction must be in isolation that is in parallel.

Durability refers to the guarantee that once the user has been notified of success, the transaction will persist, and not be undone. The database will keep track of pending changes in such a way that the server can recover from an abnormal termination.This means it will survive system failure, and that the database system has checked the integrity constraints and won't need to abort the transaction.