Cursor Stored Procedures (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure 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

See Also

System Stored Procedures (Transact-SQL)