What is ACID property of transaction in SQL Server?
What is ACID property of transaction in SQL Server?
Ask by Ashutosh Kumar Verma
Updated 15 Nov 2021
ACID Property of Transaction in SQL Server:
Transaction:
A transaction is a group of operations that are treated as just one logical operation.
Example: When we withdraw money from our bank account or deposit money in the bank account.
ACID Properties: Transaction has four properties which we call ACID Properties.
1- Atomicity.
2- Consistency.
3- Isolation.
4- Durability.
Atomicity: When the transaction is completed in a single step then the transaction is atomic.
Consistency: When the transaction takes place, the database is consistence from one state to another.
Isolation: When two or more transactions are executed simultaneously, then one transaction does not affect the other transaction.
Durability: When a transaction is completely completed then the changes that take place stay in the system permanently. That is, the transaction should be durable.