It's all about the SQL and the User

zip DeMystifying Common Table Expressions (CTE's)

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

Presented by Scott Heffron

Common table expressions (CTEs), a powerful and slick feature in SQL Server to 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.

Presentation and Example code into included in the zip file.

» Comments

    No comments exist for this file.

This Folder

Tags For This Folder