A transaction must follow ACID property rule, I will try
to explain what does ACID properties of a transaction mean. As you all
know a transaction has two states success or failure. When transaction is
successful it should commit the changes and those changes becomes permanent in
the database and if it fails in half way it then full transaction will fail and
it rolls back to the previous committed state and never change the database.
Atomicity – If
transaction is successful and committed changes will become permanent, if
transaction fail in half way full transaction will fail and no change will be
made in the database.
Consistency
– Transactions must make sure that valid data gets into the database.
Isolation
– If you are in the middle of transaction in this case other processes
won’t be able to see your data until your transaction completes with success or
failure. It keeps all transaction separate.
Durability – Once Transaction has been committed, entire data should be available in any worst condition.
Click here to know more about Transactions in SQL Server.
I hope you enjoyed the article don't forget to share on Facebook. Please leave your comments below if there are any questions.
No comments:
Post a Comment