Sensitivity

The sensitivity behavior of a cursor defines whether updates made against the base rows (used to build the cursor) are visible through the cursor. Sensitivity also defines whether updates can be made through the cursor.

If the INSENSITIVE keyword is specified on a Transact-SQL DECLARE statement, or if SQL_ATTR_CURSOR_SENSITIVITY is set to either SQL_UNSPECIFIED or SQL_INSENSITIVE in ODBC, the cursor does not reflect data modifications. The cursor is read-only and does not support updates.

If the INSENSITIVE keyword is omitted from a Transact-SQL DECLARE statement, or if SQL_ATTR_CURSOR_SENSITIVITY is set to SQL_SENSITIVE in ODBC, the cursor reflects data modifications made by the current user or committed by other users. Positioned updates can be made using the cursor, except when using a read-only cursor.

See Also