Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 cursordata 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.

    Important noteImportant

    The cursordata type cannot be used for a column in a CREATE TABLE statement.

    NoteNote

    In this version of SQL Server, 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.