HOUR 10. Working with SQL Server Views
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
An Introduction to Views
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. ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
