You can update one or more rows of a table through a view, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views. Any column that is not modified retains its original values, except in ...

SQL Server locks the rows as they are read into the cursor to ... If the row was modified, the attempted positioned update or delete fails. OPTIMISTIC cannot be specified if FAST_FORWARD is ...