• Christian Buettner (7/24/2008)


    This is a misunderstanding. What I meant to say was that when you open a static cursor, you have a point in time copy of the data as it was when you opened the cursor.

    You will not see any updates made to the underlying data after that, since you are working with a copy of the data, not the stored data itself.

    Hi Christian,

    That's true. The options STATIC and FOR UPDATE are mutually exclusive, though.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/