Skip to content

Instantly share code, notes, and snippets.

@ArCiGo

ArCiGo/1. Syntax. CURSOR.sql

Created May 20, 2019 00:32
Show Gist options
  • Save ArCiGo/1ed979debc92ff16246dcedab2a50836 to your computer and use it in GitHub Desktop.
Save ArCiGo/1ed979debc92ff16246dcedab2a50836 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
1. Syntax. CURSOR.sql
DECLARE cursor_name [ INSENSITIVE ] [ SCROLL ] CURSOR
FOR select_statement
[ FOR { READ ONLY | UPDATE [ OF column_name [ ,...n ] ] } ]
[;]
Transact-SQL Extended 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 ] ] ]
[;]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment