Cursor Stored Procedures (Transact-SQL)

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

sp_cursor (Transact-SQL)	sp_cursorunprepare (Transact-SQL)
sp_cursorclose (Transact-SQL)	sp_describe_cursor (Transact-SQL)
sp_cursorexecute (Transact-SQL)	sp_describe_cursor_columns (Transact-SQL)
sp_cursorfetch (Transact-SQL)	sp_describe_cursor_tables (Transact-SQL)
sp_cursor_list (Transact-SQL)	sp_execute (Transact-SQL)
sp_cursoropen (Transact-SQL)	sp_prepare (Transact SQL)
sp_cursoroption (Transact-SQL)	sp_prepexec (Transact-SQL)
sp_cursorprepare (Transact-SQL)	sp_prepexecrpc (Transact-SQL)
sp_cursorprepexec (Transact-SQL)	sp_unprepare (Transact-SQL)

Aanvullende resources