O'Reilly logo

Microsoft® SQL Server™ 2005: Database Essentials Step by Step by Solid Quality Learning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required