Cursor MSSQL Tutorial

DECLARE cursor_name CURSOR
    [LOCAL|GLOBAL]
    [FORWARD_ONLY|SCROLL]
    [FAST_FORWARD|STATIC|KEYSET|DYNAMIC]
    [READ_ONLY|SCROLL_LOCKS|OPTIMISTIC]
FOR select_statement
    [FOR UPDATE [OF column_name [, ...]]]