Chapter 8. Creating Views to Encapsulate Queries
After completing this chapter, you will be able to:
Create and query views
Select data from a single view
Mix data from views and tables
Work with views from within client applications
A Microsoft SQL Server 2005 database can host a wide range of database objects that provide you with more options and flexibility when designing data-centric applications. A view is one of these database objects. In this chapter, you will learn how to create and manage a view. You will also learn how to query data from a view and combine data from a view and base tables. Lastly, you will learn how to use views from client applications.
Selecting Data from a Single View
You can think of a view as a stored query that encapsulates ...
Get Microsoft® SQL Server™ 2005: Database Essentials Step by Step 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.
