• Thomas Abraham (12/23/2013)


    Wasn't really sure when I clicked 'submit'. I would have thought that KEYSET was a TYPE of cursor, and not the operator that generated the cursor.

    For example (stolen from a 2007 Grant Fritchey post):

    DECLARE CurrencyList CURSOR KEYSET FOR

    SELECT CurrencyCode FROM [Sales].[Currency]

    WHERE Name LIKE '%Dollar%'

    But, since none of the other choices seemed correct, I went with it and was rewarded with another point I can put in my retirement account.

    +1. I expected to somehow be wrong on this one although BOL pointed me at the right answer.