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
Oracle uses cursors (its version of a cursor) for all
Do you have any evidence whatsoever
that SQL uses cursors for this type of code?
SQL DBA,SQL Server MVP(07, 08, 09)[size=2]Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them.[/size]