Cursor declaration syntax : Declare CURSOR « Cursor « SQL Server / T-SQL






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]]]

 








Related examples in the same category

1.Declare a cursor
2.DECLARE CURSOR FOR