The SQL statements for cursor processing : Cursor « Cursor « SQL Server / T-SQL Tutorial






Statement      Description
DECLARE        Defines a new cursor.
OPEN           Opens and populates the cursor by executing the SELECT statement defined by the cursor.
FETCH          Retrieves a row from the cursor.
CLOSE          Closes the cursor.
DEALLOCATE     Deletes the cursor definition and releases all system resources associated with the cursor.








18.1.Cursor
18.1.1.The SQL statements for cursor processing
18.1.2.Three stored procedures that manage a global cursor
18.1.3.FAST_FORWARD cursor