Updating Data in Rowsets in SQL Server Native Client
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
The SQL Server Native Client OLE DB provider updates SQL Server 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 SQL Server Native Client OLE DB provider-modifiable rowsets use SQL Server cursors to support the rowset. The rowset property DBPROP_LOCKMODE alters SQL Server concurrency control behavior in cursors and determines the behavior of rowset row fetching and data integrity error generation in updatable rowsets.
The SQL Server 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.
In This Section
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for