In Review


This chapter provides an in-depth discussion of the mainstay of the SQL language, SELECT, and its Transact-SQL “additives.” We looked at how SELECT queries can be used to join rows from more than one table using join constructions and view definitions.

The new support for indexed views was also discussed, as was Microsoft’s scale-out strategy for distributed partitioned views, which are built across linked servers that are combined to provide a load-balanced, single, federated access to data.

While this chapter concentrates primarily on query (returning result sets), the next chapter looks at the data manipulation language (DML).




Microsoft SQL Server 2005. The Complete Reference
Microsoft SQL Server 2005: The Complete Reference: Full Coverage of all New and Improved Features
ISBN: 0072261528
EAN: 2147483647
Year: 2006
Pages: 239

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net