.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Transaction in Sql server

Posted By:Dhivakaran       Posted Date: October 31, 2010    Points: 50    Category: DataBase    URL: http://www.dotnetspark.com  

Transaction is a sequence of operation performed as a single logical unit of work which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction
 

Transaction is a sequence of operation performed as a single logical unit of work  which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction

 Transaction has five main properties called ACIDS:

1. Atomicity 

All parts of the transaction are executed or else the transaction is aborted.

2. Consistency 

Indicates the permanence of the database's consistent state. When a transaction is 

completed the database reaches a consistence state.

3. Isolation 

 Means that the data used during the execution of a transaction cannot be used by the a second transaction until the first transaction is complete.

4. Durability 

Ensures that once transaction changes are committed, they cannot be lost even in the event of system failure.

5. Serializability 

Ensures that concurrent execution of several transaction yields consistent results. This 

property is important in a multi-user and distributed databases, where multiple transaction are likely to be executed concurrently


 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend