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