| title | Updating data in rowsets (Native Client OLE DB provider) | ||||||
|---|---|---|---|---|---|---|---|
| description | Updating Data in Rowsets in SQL Server Native Client | ||||||
| author | markingmyname | ||||||
| ms.author | maghan | ||||||
| ms.date | 03/14/2017 | ||||||
| ms.service | sql | ||||||
| ms.subservice | native-client | ||||||
| ms.topic | reference | ||||||
| helpviewer_keywords |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
The [!INCLUDEssNoVersion] Native Client OLE DB provider 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 [!INCLUDEssNoVersion] Native Client OLE DB provider-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 [!INCLUDEssNoVersion] Native Client OLE DB provider 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.