Cursors in procedures, triggers, user-defined functions, and batches

Cursors retrieve rows one at a time from a query or stored procedure with multiple rows in its result set. A cursor is a handle or an identifier for the query or procedure, and for a current position within the result set.


Cursor management
Cursors on SELECT statements
Positioned updates inside procedures, triggers, user-defined functions, batches