Cursor Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Microsoft SQL Server supports the following system stored procedures that implement cursor variable functionality.

sp_cursor_list sp_cursorprepare
sp_cursor sp_cursorprepexec
sp_cursorclose sp_cursorunprepare
sp_cursorexecute sp_describe_cursor
sp_cursorfetch sp_describe_cursor_columns
sp_cursoropen sp_describe_cursor_tables
sp_cursoroption

See Also

System Stored Procedures (Transact-SQL)