SQL Server Common Table Expression Hierarchical Example(wijix.com)
submitted by
bmerrell(330) 3 years, 10 months ago
SQL Server 2005 provides a mechanism called CTE or Common Table Expressions for pre-loading data or setting up for later use. It is really fast compared to pre-2005 which did not have such a feature. To illustrate I'll take some hierarchical data and load it into a CTE.
|category: Database
|Views: 15
tags:
Database another
Everyones tags:
Your Tags: