September 2010
Intermediate to advanced
1704 pages
111h 8m
English
The CREATE VIEW statement is used to create views with T-SQL. The syntax for the CREATE VIEW statement follows:

This statement and the related options are essentially the same in SQL Server 2008 as they were in SQL Server 2005 and SQL Server 2000. We first look at a simple example for creating a view with T-SQL and then delve into several other examples that utilize the view attributes. Listing 27.2 shows a sample T-SQL statement for creating a simple view.
Listing 27.2 Creating a Simple View with T-SQL

There are several ...