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 ...

The first thing you need to ascertain is the version of SQL Server you are currently running and the most current update to your version. To check the version number for a running SQL Server database, ...