Table expressions

SQL 2005 Adventure Works OLTP

SQL 2005 Adventure Works OLTP

The views listed are dynamic views into joined data. They are commonly refered to as Common Table Expressions.

BOM_cte used in procedure: dbo.uspGetBillOfMaterials
BOM_cte used in procedure: dbo.uspGetWhereUsedProductID
EMP_cte used in procedure: dbo.uspGetEmployeeManagers
EMP_cte used in procedure: dbo.uspGetManagerEmployees

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007

Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.