Microsoft SQL ServerPHANTOM read


Introduction

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.

Remarks

You can read the various ISOLATION LEVEL on MSDN