Chapter 8: Creating Views to Encapsulate Queries

image from book  Download CD Content

Overview

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.



Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net