Chapter 8: Views


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




Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL &  .NET
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
ISBN: 0072262281
EAN: 2147483647
Year: 2006
Pages: 165

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