sp_cursorclose (Transact-SQL)
Applies to:
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.
Transact-SQL syntax conventions
Syntax
sp_cursorclose cursor
[ ; ]
Arguments
cursor
A cursor handle value generated by SQL Server 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.
Remarks
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
.
Related content
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre