Mega Code Archive

 

Categories / MSSQL Tutorial / Cursor

 

The syntax of the DECLARE CURSOR statement

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 [, ...]]]