Updating table from a view in sql
The following Transact-SQL statement selects all the data for the view shown in Listing 9.1, sorting the result set on the Company Name column: statement wouldn't have to change. Company Name Views are created inside individual databases, however, views can reference tables and views in other databases or even on other servers (if the view is defined using distributed queries).
Another limitation of views that you may be familiar with is that a view cannot be indexed. In SQL Server 2000, you can indeed create indexed views, as shown later in this chapter.
Views, which are a type of virtual tables allow users to do the following − Database views are created using the CREATE VIEW statement.
Views can be created from a single table, multiple tables or another view.
Views can be used in place of tables in your Access front-end application, whether you're using an Access database or an Access project.
Views can also reference functions and other views.