O'Reilly logo

Sams Teach Yourself T-SQL in One Hour a Day by Alison Balter

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

Lesson 12. Working with SQL Server Views

A view is a saved SELECT statement. A view can retrieve data from one or more tables. After you create a view, you can select data from it just as you can select it from a table. In this lesson, you learn:

Image What views are and why you would want to use them

Image How to use the SQL Server Management Studio Query Builder to create a view

Image How to use T-SQL to create or modify a view

An Introduction to Views

Views can ...

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