• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with SQL Server Views > Why This Chapter Is Important

Why This Chapter Is Important

A view is a saved SELECT statement. A view can retrieve data from one or more tables. Once a view is created, you can select data from a view just as you can select it from a table. Views allow you to select data; they cannot update data (although you can update the data in the result of a view). For example, a T-SQL UPDATE statement in a stored procedure updates data. Although you cannot use a T-SQL UPDATE statement in a view, you can update the results returned from a SELECT statement.

Views have several advantages. They allow you to:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint