Cursor Stored Procedures (Transact-SQL)

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

Reference

System Stored Procedures (Transact-SQL)