Magazine article from our research archive:

T-SQL 101: VIEWS

In Lesson 7, learn how and when to use views

(ProQuest: ... denotes formulae omitted.)

Up until this point, I've covered how to manipulate data stored in physical tables. Now I'll introduce you to querying data represented by virtual tables. These virtual tables are SQL constructs known as views.

Unlike conventional physical tables, views don't contain data. A view is merely a stored SQL statement that, when executed, generates a result set. When you query a view, you're really querying the result set of a previously defined query. By the end of this lesson, you'll have a firm grasp of views and how to create them. You'll also understand the advantages and disadvantages of using them.

The ...

Related newspaper, magazine, and journal articles:

See all results. Or, try our Advanced Search.

Newsweek Harper's Magazine The Washington Post Chicago Tribune Crain's Chicago Business PRNewswire Pediatric News The Nation Advertising Age The Economist (US) A FREE trial gives you access to over 60 million articles! Access over 3,500 publications with a FREE trial!