Microsoft® SQL Server 2012 Unleashed

Data Modifications and Views

Data modifications are allowed through a view under certain circumstances. 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 = ExpYear + 1 WHERE ExpYear < 2006

In general, updatable views are similar to the previous ...