Cursor Behaviors

Accessing and Changing Relational Data

previous page next page
Accessing and Changing Relational Data

Cursor Behaviors

Both ODBC and Transact-SQL cursors support specifying cursor characteristics using the SQL-92 cursor behaviors of scrollability and sensitivity.

Cursor behaviors are specified in the following ways:

  • Transact-SQL cursors use the SQL-92 syntax of specifying SCROLL and INSENSITIVE before the CURSOR keyword on the DECLARE statement.

  • The ODBC API uses the SQL_ATTR_CURSOR_SCROLLABLE and SQL_ATTR_CURSOR_SENSITIVITY statement attributes.

See Also

DECLARE CURSOR

How Cursors Are Implemented

previous page start next page