What is SQL Server Updatable Views?
#decodeites
Views are virtual tables that are used to fetch data from underlying tables. Tables are objected to where actual data resides and valid for all DML operations.
a
SQL Server gives you capabilities of updating table data through views called SQL Server Updatable Views.
Does & Don’ts of Updatable Views
DML Operations like UPDATE, INSERT, and DELETE statements, must target columns from only one base table.
The columns being modified are not affected by GROUP BY, HAVING, or DISTINCT clauses.
The view you want to update is based upon another view, the later should be updatable with the same requirements.
Subqueries used in view definition must comply with the same requirements.