It's all about the SQL and the User

zip DeMystified Common Table Expressions (CTE's)

Downloads: 1,088 File Size: 0 B
Posted By: sheffron Views: 1,232
Date Added: 05-11-2009

Presented by Scott Heffron

ommon table expressions (CTEs), a powerful and slick new feature in SQL Server 2005, make your SQL more readable and easier to maintain. They are similar to aliases (as in SELECT T1.* FROM MyTable T1) but much more useful. In essence, a CTE is a temporary result set that exists only within the scope of the statement in which it occurs.

Attached is the presentation and example code.

» Comments

    No comments exist for this file.

This Folder

Tags For This Folder