| title | sp_cursorclose (Transact-SQL) | ||
|---|---|---|---|
| description | sp_cursorclose closes and deallocates the cursor, and releases all associated resources. | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Closes and deallocates the cursor, and 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.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_cursorclose cursor
[ ; ]
[!INCLUDE extended-stored-procedures]
A cursor handle value generated by [!INCLUDE ssNoVersion] and returned by the sp_cursoropen procedure. The cursor parameter is int and can't be NULL.
An input value of -1 applies toward all cursors on the current connection.
cursor 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.
DONE rowcount is always 0.