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.