Choosing the correct isolation level
Non-repeatable reads occur when a transaction reads a record twice, but the first result is different from the second result as a consequence of another committed transaction altering this data.
From all the isolation levels you have studied so far, which isolation level prevents non-repeatable reads?
This exercise is part of the course
Transactions and Error Handling in SQL Server
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
