Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - "DECLARE ... CURSOR" - Declaring Cursor Objects
(Continued from previous topic...)
How To Declare a Cursor with "DECLARE ... CURSOR"?
If you want to use a cursor to represent the result set of a query,
you need to define a cursor name with a SELECT sub-statement using
the "DECLARE ... CURSOR" statement using the following syntax format:
DECLARE cursor_name CURSOR FOR
Note that the DECLARE statement will not actually execute the SELECT
sub-statement. It only attaches the SELECT sub-statement to the cursor.
A cursor name should be deallocated to free up server resources if the cursor
is not needed any more.
The tutorial example below shows you how to declare and deallocate a cursor.
DECLARE fyi_cursor CURSOR FOR
SELECT * FROM fyi_links;
-- other statements
(Continued on next topic...)
- What Are Cursors?
- How To Declare a Cursor with "DECLARE ... CURSOR"?
- How To Execute the Cursor Queries with "OPEN" Statements?
- How To Fetch the Next Row from a Cursor with a "FETCH" Statement?
- How To Transfer Data from a Cursor to Variables with a "FETCH" Statement?
- How To Loop through the Result Set with @@FETCH_STATUS?
- How To Declare and Use Cursor Variables?
- How To Create a Scrollable Cursor with the SCROLL Option?
- How To Create a Dynamic Cursor with the DYNAMIC Option?