Cursor Concurrency (ODBC)

• 03/06/2017
• 2 minutes to read
• • m
  • j
  • M
  • M
  • r
  • +3

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Parallel Data Warehouse

Cursor operations, like cursor types, are affected by the concurrency options set by the application. Concurrency options are set using the SQL_ATTR_CONCURRENCY option of SQLSetStmtAttr. The concurrency types are:

• Read-only (SQL_CONCUR_READONLY)

• Values (SQL_CONCUR_VALUES)

• Row version (SQL_CONCUR_ROWVER)

• Lock (SQL_CONCUR_LOCK)

See Also

Cursor Properties