Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Cursor Behaviors (Database Engine)

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

Cursor behaviors are specified in the following ways:

  • Transact-SQL cursors use the ISO 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.