| |
| |
|
|
T-SQL Cursors
|
Cursors - Microsoft SQL Server transact sql 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.
Transact-SQL Cursors - Transact-SQL cursors are used mainly in
stored procedures, triggers, and Transact-SQL scripts in which they make
the contents of a result set available to other Transact-SQL statements.
|
|
|
|
|