Microsoft SQL ServerPHANTOM read


In database systems, isolation determines how transaction integrity is visible to other users and systems, so it defines how/when the changes made by one operation become visible to other. The phantom read may occurs when you getting data not yet commited to database.


You can read the various ISOLATION LEVEL on MSDN