December 24, 2013 at 7:14 pm
I agree with Hugo here. But unlike him I thought the question wasn't worth doing any serious research on, so I didn't spot that "snapshot" had some reference to "cursor" in the documentation (and to me, a snapshot sounds like a spool, not a cursor, so I didn't consider it a possible answer). So I picked keyset (which sounds like a property of a cursor) plus the first of the other three options (excluding snapshot) , to see what the answer would be.
While the referenced page certainly says that the snapshot operator creates a cursor, I think Hugo is right to say that it's actually the other way round.
Tom
December 26, 2013 at 10:58 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 29, 2013 at 11:30 pm
Wow... Thats a good one. I don't use cursors because of some obvious reasons and hence have to do some r&d for it's each question. 🙂
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply