Microsoft SQL Server 2014 Unleashed

Data Modifications and Views

Data modifications are allowed through a view under certain circumstances. When you execute DML statements against the view then the underlying tables are affected. Views that meet these criteria are sometimes called updatable views. Updatable views can be referenced in an INSERT, UPDATE, or DELETE statement, and these statements ultimately affect the underlying table(s) in the view.

The following example contains a SQL statement to create an updatable view, followed by an UPDATE statement that performs a data modification using the view:

Click here to view code image

CREATE VIEW vw_CreditCardASSELECT     CreditCardID, CardType, CardNumber, ExpMonth, ExpYearFROM         Sales.CreditCardUPDATE vw_CreditCard SET ExpYear ...