Mega Code Archive

 

Categories / MSSQL / Cursor

 

Cursor declaration syntax

DECLARE <cursor name> CURSOR [LOCAL|GLOBAL] [FORWARD_ONLY|SCROLL] [STATIC|KEYSET|DYNAMIC|FAST_FORWARD] [READ_ONLY | SCROLL_LOCKS | OPTIMISTIC] [TYPE_WARNING] FOR <SELECT statement> [FOR UPDATE [OF <column name >[,...n]]]