Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Cursors (Transact-SQL)

Cursors (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Microsoft SQL Server statements produce a complete result set, but there are times when the results are best processed one row at a time. Opening a cursor on a result set allows processing the result set one row at a time. You can assign a cursor to a variable or parameter with a cursor data type.

Cursor operations are supported on these statements:

         CLOSE       

         CREATE PROCEDURE       

         DEALLOCATE       

         DECLARE CURSOR       

         DECLARE @local_variable       

         DELETE       

         FETCH       

         OPEN       

         UPDATE       

         SET       

These system functions and system stored procedures also support cursors:

         @@CURSOR_ROWS       

         CURSOR_STATUS       

         @@FETCH_STATUS       

         sp_cursor_list       

         sp_describe_cursor       

         sp_describe_cursor_columns       

         sp_describe_cursor_tables       

Community Additions

ADD
Show:
© 2015 Microsoft