To create a view using a SQL-derived table, add the derived table expression in the from clause of the select part of the create view statement.
A view created using a SQL-derived table can be updated if the derived table expression can be updated. The update rules for the derived table expression follow the update rules for the select part of the create view statement.
Data can be inserted through a view that contains a SQL-derived table if the insert rules and permission settings for the derived table expression follow the insert rules and permission settings for the select part of the create view statement.
Temporary tables and local variables are not permitted in a derived table expression that is part of a create view statement.
SQL-derived tables cannot have unnamed columns.
For more information about derived table expressions, see the Transact-SQL Users Guide.