| title | cursor (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 07/23/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database | |
| ms.reviewer | ||
| ms.technology | t-sql | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | fbea16ef-f2cc-4734-9149-ec2598fd3cca | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
A data type for variables or stored procedure OUTPUT parameters that contain a reference to a cursor.
The operations that can reference variables and parameters having a cursor data type are:
- The DECLARE @local_variable and SET @local_variable statements.
- The OPEN, FETCH, CLOSE, and DEALLOCATE cursor statements.
- Stored procedure output parameters.
- The CURSOR_STATUS function.
- The sp_cursor_list, sp_describe_cursor, sp_describe_cursor_tables, and sp_describe_cursor_columns system stored procedures.
The cursor_name output column of sp_cursor_list and sp_describe_cursor returns the name of the cursor variable.
Any variables created with the cursor data type are nullable.
The cursor data type cannot be used for a column in a CREATE TABLE statement.
CAST and CONVERT (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Data Type Conversion (Database Engine)
Data Types (Transact-SQL)
DECLARE CURSOR (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
SET @local_variable (Transact-SQL)