SQLOLEDB updates SQL Server data when a consumer updates a modifiable rowset containing that data. A modifiable rowset is created when the consumer requests support for either the IRowsetChange or IRowsetUpdate interface.
All SQLOLEDB modifiable rowsets use SQL Server cursors to support the rowset. The SQLOLEDB provider-specific rowset property SSPROP_CONCURRENCY alters SQL Server concurrency control behavior in cursors and determines the behavior of rowset row fetching and data integrity error generation in updatable rowsets.
SQLOLEDB supports row synchronization before or after an update.