I've been reading the DECLARE CURSOR (Transact-SQL) Books Online article. It states:

FAST_FORWARD: Specifies a FORWARD_ONLY, READ_ONLY cursor with performance optimizations enabled.


FORWARD_ONLY: Specifies that the cursor can only be scrolled from the first to the last row. FETCH NEXT is the only supported fetch option. If FORWARD_ONLY is specified without the STATIC, KEYSET, or DYNAMIC keywords, the cursor operates as a DYNAMIC cursor.

Does this mean that a FAST_FORWARD cursor is a DYNAMIC cursor by default, unless I also specify that it's STATIC?

  • 3
    See Paul's answer here and the accompanying link. May 3, 2018 at 2:38
  • @PaulWhite: Although your answer to the other question answers this one I don't think the two questions are identical. This one is a specific question about a FAST_FORWARD cursor, the other one is about parallelism and cursors. Having said that, however, I'm very much a newbie in this forum so I'll leave it you to determine whether it should be marked as a duplicate or not. May 3, 2018 at 22:25


Browse other questions tagged or ask your own question.