1 out of 1 rated this helpful - Rate this topic

Cursor Stored Procedures (Transact-SQL)

SQL Server 2008 R2

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)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions