Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

cursor (Transact-SQL)

A data type for variables or stored procedure OUTPUT parameters that contain a reference to a cursor. Any variables created with the cursor data type are nullable.

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.
    ms190498.note(en-US,SQL.90).gifImportant:
    The cursor data type cannot be used for a column in a CREATE TABLE statement.

    ms190498.note(en-US,SQL.90).gifNote:
    In SQL Server 2005, the cursor_name output column of sp_cursor_list and sp_describe_cursor returns the name of the cursor variable. In previous releases, this output column returns a system-generated name.

Community Additions

ADD
Show:
© 2015 Microsoft