sys.sp_cursorclose

Description

Closes and deallocates the cursor, and releases all associated resources; that is, it drops the temporary table used in support of in a tabular data stream (TDS) packet. value generated by SQL Server and returned by the An input value of applies toward all cursors on the current connection. will return error messages if the procedure was run after the cursor was closed, or if an invalid handle is specified. RPC status indicates overall success or failure. Arguments for extended stored procedures must be entered in the specific order as described in the section. If the parameters are entered out of order, an error message occurs.

Syntax

sp_cursorclose cursor
[ ; ]

Remarks

Closes and deallocates the cursor, and releases all associated resources; that is, it drops the

temporary table used in support of

is invoked by

in a tabular data stream (TDS) packet.

value generated by SQL Server and returned by the

parameter is

and can’t be

An input value of

applies toward all cursors on the current connection.

will return error messages if the procedure was run after the cursor was closed, or if an

invalid handle is specified.

RPC status indicates overall success or failure.

Arguments for extended stored procedures must be entered in the specific order as

described in the

section. If the parameters are entered out of order, an error

message occurs.