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 overview
Using cursors on SELECT statements in procedures
Updating a cursor inside a stored procedure