Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

Common Table Expressions (CTEs) in SQL Server 2005 (Video Series)

Video Image Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005
CTEs were added to SQL Server 2005 to simplify your recursive and heirarchical queries. This video series shows you the syntax and some common use of CTEs along with some "gotchas" of working with recursion

Videos in this Series:


Miscellaneous Bits & Pieces:
Book You Should Probably Own: Michael Hernandez's "Database Design for Mere Mortals"
Book You Should Probably Own: Rob Viera's "Beginning SQL Server 2005 Programming"
The TIMESTAMP data type name was replaced in Microsoft SQL Server 2000 by the ROWVERSION data type. They are the same; nothing changes but the name

Other Websites We Offer
LearnCSharp.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
9/7/2008 9:27:00 PM