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 (Database Engine)

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.

Community Additions

ADD
Show:
© 2015 Microsoft