Chetana Barot
What are dirty reads in SQL
By Chetana Barot in SQL Server on Aug 28 2017
  • Manish Kumar
    Nov, 2017 17

    Dirty reads lets say you are trying to update a table with some where condition inside a transaction and transaction is not yet committed .In another window you are selecting that where condition record with nolock then it will show that records which are changed but not committed yet.Mean to say there is no guarantee of valid data. This is known as Dirty reads and can found in Isolation level of Read Uncommited stage

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS