United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

System Stored Procedures (Transact-SQL)

Cursor Stored Procedures (Transact-SQL)

sp_cursor_list (Transact-SQL)

sp_cursor (Transact-SQL)

sp_cursorclose (Transact-SQL)

sp_cursorexecute (Transact-SQL)

sp_cursorfetch (Transact-SQL)

sp_cursoropen (Transact-SQL)

sp_cursoroption (Transact-SQL)

sp_cursorprepare (Transact-SQL)

sp_cursorprepexec (Transact-SQL)

sp_cursorunprepare (Transact-SQL)

sp_describe_cursor (Transact-SQL)

sp_describe_cursor_columns (Transact-SQL)

sp_describe_cursor_tables (Transact-SQL)

sp_execute (Transact-SQL)

sp_prepare (Transact SQL)

sp_prepexec (Transact-SQL)

sp_prepexecrpc (Transact-SQL)

sp_unprepare (Transact-SQL)

Minimize

1 out of 3 rated this helpful - Rate this topic

Cursor Stored Procedures (Transact-SQL)

SQL Server 2012

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

Reference

System Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.