Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - What Are Cursors
(Continued from previous topic...)
What Are Cursors?
A cursor is a special data type that represents a result set returned by a SELECT query
statement. There are several notes about cursor you need to remember:
- Cursor data type can not be used to define table columns.
- Cursor data type is used on store procedures, functions, and triggers
to help you loop through result sets returned by queries.
- Cursor data type can be used to define cursor variables.
- There are special Transact-SQL statements dedicated to work with cursors variables:
OPEN, FETCH, CLOSE, and DEALLOCATE.
- Cursor variables can be passed as procedure or function parameters.
- There is a special function, CURSOR_STATUS(), for check cursor statuses.
(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?