What is dirty read in SQL Server? Accenture SQL Interview
In simple word you can define dirty read like, reading any value from any other transaction which is still not committed.
Example. Suppose there are two Transaction T1,T2,
T1 writing any variable value in DB and still not committed.
Same time if T2 try to Read the value before T1 committing,then its call Dirty Read, Because there are chance that T1 may Roll Back,but T2 using the Value which T1 wrote before Rollback.
Note: Questions asked during Accenture SQL Interview
Example. Suppose there are two Transaction T1,T2,
T1 writing any variable value in DB and still not committed.
Same time if T2 try to Read the value before T1 committing,then its call Dirty Read, Because there are chance that T1 may Roll Back,but T2 using the Value which T1 wrote before Rollback.
Note: Questions asked during Accenture SQL Interview
Comments