Common Table Expressions (CTEs): What They Are and How to Use Them - view details
In this video Scott will introduce Common Table Expressions, the final topic in chapter 6. Scott will cover the basics of CTEs and show you how to use them.
Highlights from this video:Two ways to use CTEs
replacement for derived tableto make recursion "easier"
When would you use CTEs?
and much more Source: http://www.learnitfirst.com/Course/160/Video/2411/Common-Table-Expressions.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 500 (Advanced) Length: 10:15 (26.0MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql server, queries, subqueries, cte, derived table, recurions, common table expression
This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.
« SSIS 2008 Training Video: Get to Know the SSIS Lookup Transformat ion to Lookup Values in an Access 2007 DB, Part 2 | Main | SSIS 2008 Training Video: Using Variables in the Foreach Containe r: Looping Through Every Row in a Table/Result Set, Part 2 »
December 16, 2010
TrackBack
TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341c0d6c53ef0147e0c2c6c6970b
Listed below are links to weblogs that reference SQL Server 2005/2008 Queries Training Video: Common Table Express ions (CTEs): What They Are and How to Use Them:
