| |
* Fetch
:
: An operation that retrieves a row or block of rows from a cursor. T-SQL batches, SPs, and Triggers use the FETCH statement to fetch from T-SQL Cursors.
|
* Fetch Variable
:
: FETCH command also allows you to store the returned column values into variables
|
* Fetch (First, Next, Last, Prior)
:
: “FIRST” returns the First row, “LAST” returns the Last row, “NEXT” returns the Next row from the current row, “PRIOR” returns the Previous row from the current row
|
* Fetch Absolute
:
: Used to specify absolute position in the cursor set.
|
* Fetch Relative
:
: “RELATIVE” n returns a Row “n” rows From the current Row. “RELATIVE” -n returns a Row “n” rows Before the current Row.
|
* Fetch Firehose
:
|
* Monitoring Cursor
:
|