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

However, the ANSI SQL 2011 update to the standards specified that ... the VALIDFROM and VALIDTO columns, which tells SQL Server which snapshot of the temporal table to use when querying for data from ...