• Dird (4/23/2013)


    Evil Kraig F (4/22/2013)


    There's no cursor in his solution.

    Is there any documentation/book which proves this? Oracle would be running implicit cursors here; I have a hard time believing sql server doesn't since so much of this rdbms is "coincidentally" similar

    I'm unable to test now (at work) but I'll run a similar kind of operation on a large table later & query sys.dm_exec_cursors

    Dird

    Oracle uses cursors (its version of a cursor) for all queries.

    Do you have any evidence whatsoever that SQL uses cursors for this type of code?

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.