In sql server every transaction should follow acid properties
Atomicity
Consistency
Isolation
Durability
Atomicity: transaction ensures that either modifications are committed or not committed.
Consistency: The data should be in consistent state when transaction process is completed.
Isolation: A transaction work in isolation and does not allow other transactions to work concurrently on same piece of work.
Durability: Data is permanent once transaction is completed and it can be recovered when system fails.
Atomicity
Consistency
Isolation
Durability
Atomicity: transaction ensures that either modifications are committed or not committed.
Consistency: The data should be in consistent state when transaction process is completed.
Isolation: A transaction work in isolation and does not allow other transactions to work concurrently on same piece of work.
Durability: Data is permanent once transaction is completed and it can be recovered when system fails.
No comments:
Post a Comment