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) 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.