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