A view is a saved
select statement. A view can retrieve data from one or more tables. After it is created, you can select data from a view just as you can select it from a table. In this hour you’ll learn:
Views can only select data. They cannot update it (although you can update the data in the result of a view). For example, a T-SQL
UPDATE statement in a stored procedure updates data. Although you cannot use a T-SQL
UPDATE statement in a view, you can update the results returned from a
SELECT statement. ...