This topic has not yet been rated - Rate this topic

sp_cursorclose (Transact-SQL)

Closes and de-allocates the cursor, as well as releases all associated resources; that is, it drops the temporary table used in support of KEYSET or STATIC cursor. sp_cursorclose is invoked by specifying ID = 9 in a tabular data stream (TDS) packet.

Topic link icon Transact-SQL Syntax Conventions

sp_cursorclose cursor

Arguments

cursor

Is a cursor handle value generated by SQL Server and returned by the sp_cursoropen procedure. cursor is a required parameter that calls for an int input value.

Note
An input value of -1 will apply towards all cursors on the current connection.

Remarks

cursor will return error messages if the procedure was run after the cursor had been closed or if an invalid handle is specified.

RPC status indicates overall success or failure.

DONE rowcount is always 0.

Other Resources

sp_cursoropen (Transact-SQL)

System Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

sp_cursorclose (Transact-SQL)

Other Resources

Community Additions