The SQL Server Native Client OLE DB provider supports dirty read isolation when the rowset concurrency is read-only.
So back to my question, I want to know how I can edit the values of one specific record/row.
I have tried the following: This was my try of updating the firs_Name in the second row only.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
When the consumer requests a modifiable rowset, the concurrency control is controlled by DBPROP_LOCKMODE.
To modify the level of concurrent access control, the consumer sets the DBPROP_LOCKMODE property before opening the rowset.
Describes the database application programming interfaces (APIs) that support options for updating data at the current position of a result set.
Transact-SQL server cursors also support updating data at the current row of a cursor.
='DHB' ) ; merge into FA_SUBLEDGER_MST s1 using ( select SL_CODE, OFFICE_ID, OFFICE_TYPE from EMPLOYEE_MST where OFFICE_TYPE !