title

Cursors (Transact-SQL) | Microsoft Docs

ms.custom

ms.date

03/16/2017

ms.prod

sql-non-specified

ms.reviewer

ms.suite

ms.technology

database-engine

ms.tgt_pltfrm

ms.topic

language-reference

dev_langs

TSQL

helpviewer_keywords

statements [SQL Server], cursors

functions [SQL Server], cursors

cursors [SQL Server], statements

ms.assetid

63000023-54fc-4efc-a30f-fb4d4db73aae

caps.latest.revision

author

BYHAM

ms.author

rickbyh

manager

jhubbard

Cursors (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

[!INCLUDEmsCoName] [!INCLUDEssNoVersion] statements produce a complete result set, but there are times when the results are best processed one row at a time. Opening a cursor on a result set allows processing the result set one row at a time. You can assign a cursor to a variable or parameter with a cursor data type.

Cursor operations are supported on these statements:

CREATE PROCEDURE

DEALLOCATE

DECLARE CURSOR

DECLARE @local_variable

These system functions and system stored procedures also support cursors:

@@CURSOR_ROWS