June 2006
Beginner
456 pages
10h 3m
English
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:
• What views are and why you would want to use them
• How to use the SQL Server Management Studio Query Builder to create a view
• How to use T-SQL to create or modify a view
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. ...
Read now
Unlock full access