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

Get Sams Teach Yourself T-SQL in One Hour a Day now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.