Programming in MS SQL Server 2012

Close Cursor



Closes an open cursor by releasing the current result set and freeing any cursor locks held on the rows on which the cursor is positioned.

CLOSE leaves the data structures accessible for reopening, but fetches and positioned updates are not allowed until the cursor is reopened.

CLOSE must be issued on an open cursor; it is not allowed on cursors that have only been declared or are already closed.

* * * * *


Email Your Comment To AUTHOR