Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Overview

Views are database objects that behave like stored queries or virtual tables. There are several types of views, and they differ in internal design and purpose:

• Standard SQL Dynamic

• Temporary (CTEs—Common table expressions)

• INFORMATION_SCHEMA

• Indexed

• Partitioned