The same thing could happen with any other form of concurrency. In this case you could wrap the two statements in a transaction with the appropriate isolation l

The same thing could happen with any other form of concurrency. In this case you could wrap the two statements in a transaction with the appropriate isolation level. Not sure what it is called — read consistent? Snapshot?