DEALLOCATE a cursor : DEALLOCATE cursor « Cursor « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Cursor
  3. DEALLOCATE cursor
4> USE master
5> GO
Changed database context to 'master'.
1>
2> CREATE PROC sp_cursor_info
3> (@scope int = 3)
4> AS
5> DECLARE @Report CURSOR
6> EXEC master.dbo.sp_cursor_list @cursor_return = @Report OUTPUT,
7>
8> @cursor_scope = @scope
9> FETCH NEXT FROM @Report
10> WHILE (@@FETCH_STATUS = 0)
11> BEGIN
12>     FETCH NEXT FROM @Report
13> END
14> CLOSE @Report
15> DEALLOCATE @Report
16> RETURN
17> GO
1>
2>








18.7.DEALLOCATE cursor
18.7.1.Fetching cursor data into variables and DEALLOCATE cursor
18.7.2.DEALLOCATE a cursor