| title | Updating data in rowsets (OLE DB driver) | ||||||
|---|---|---|---|---|---|---|---|
| description | Learn how the OLE DB Driver for SQL Server updates SQL Server data when a consumer updates a modifiable rowset that contains that data. | ||||||
| author | David-Engel | ||||||
| ms.author | davidengel | ||||||
| ms.date | 06/14/2018 | ||||||
| ms.service | sql | ||||||
| ms.subservice | connectivity | ||||||
| ms.topic | reference | ||||||
| ms.custom |
|
||||||
| helpviewer_keywords |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
The OLE DB Driver for SQL Server updates [!INCLUDEssNoVersion] data when a consumer updates a modifiable rowset that contains that data. A modifiable rowset is created when the consumer requests support for either the IRowsetChange or IRowsetUpdate interface.
All OLE DB Driver for SQL Server-modifiable rowsets use [!INCLUDEssNoVersion] cursors to support the rowset. The rowset property DBPROP_LOCKMODE alters [!INCLUDEssNoVersion] concurrency control behavior in cursors and determines the behavior of rowset row fetching and data integrity error generation in updatable rowsets.
The OLE DB Driver for SQL Server supports row synchronization before or after an update.
Note
IRowChange::SetColumns is available to set the values of one or more named columns of a row object.