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.
You can think of a view as a stored query that encapsulates ...