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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.