• brewmanz (7/24/2008)


    I used the following extract from BOL

    (...)

    Was it a fluke, or is it some indirect help from BOL? Or maybe direct help - cursors are a bit of a *gasp* grey area for me!

    Hi Brewmanz,

    That bit in Books Online is about client-side cursors, not about T-SQL cursors. When I submitted the question, it didn't occur to me to think about possible confusion with client-side cursors. That's the problem with beiing a "pure" T-SQL coder - one often tends to forget that the data is eventuallly served to and consumed by a client!


    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/