MSSQL Non-Repeatable Read

Non-repeatable reads happen when a query returns data that would be different if the query were repeated within the same transaction. Non-repeatable reads can occur when other transactions are modifying data that a transaction is reading. Non-repeatable reads can be prevented by using SERIALIZABLE isolation level, the highest level.

Leave a Reply

Your email address will not be published. Required fields are marked *