ACID Properties in SQL Server

Atomicity: 

In Simple word say in side transaction’s all operation (insert, update, delete) is either successfully committed or rolled back, it is never allow to some transaction committed and rollback.

Consistency:

it is provide the guarantees that transaction never leave on half-finished state, like

• If the transaction is completed then it will apply all the changes in database.
• If any error comes or system failure inside of transaction then must be all changed rolled back.

Isolation:

Each and every transaction is individual.

Durability:

Ability of the system to recover committed transaction updates if either the system or the storage media fails.