What is dirty read?

Ads

 
 

Share on Google+Share on Google+

hemant kumar
What is dirty read?
1 Answer(s)      6 years and 11 months ago
Posted in : SQL

What is dirty read?

Ads
View Answers

November 15, 2010 at 3:21 PM


Hi,

Dirty read is caused when the TRANSACTION ISOLATION LEVEL is set to READ UNCOMMITTED. This isolation level neither issues a shared lock nor issues exclusive locks. The statements in the current transaction can modify the data that has not been committed by other transactions. It leads to the removal or change in the data before the completion of the current transaction. The shared and exclusive locks prevent the statements in the current transaction to read the data that has not been committed by other transactions.


Ads









Ads

 
Advertisement null

Ads