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

Top 5 Contributors of the Month
Sharon Maxwell

Home >> Code Snippets >> SQL Query >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets


Posted By:Athira Sreejith       Posted Date: December 31, 2008    Points: 10    Category: SQL Query    URL: http://www.dotnetspark.com  


A transaction is a logical unit of work ,that must either be completely executed or aborted ,no intermediate states are acceptable.

A transaction is a single logical unit of work.
A transaction must take a DB from one consistent state to 
another consistent state.
Every transaction should execute as if it is the only transaction existing
in the system.
Once a transaction has completed successfully,the updated tuples
must be available for all other transaction on a permanent basis.

This is calles ACID Property


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

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