Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Cursor Behaviors

SQL Server 2000

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

Show:
© 2015 Microsoft