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

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

Video Image Video Category: T-SQL Basics: Queries, Datatypes, Collations and Unicode, 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:
Microsoft SQL Server was originally licensed from Sybase in 1989 and proceeded to be a co-operative design until Microsoft SQL Server 7.0 - the first stand-alone version produced solely by Microsoft
Helpful Keyboard Shortcuts: "Windows key" + "E" quickly brings up Windows Explorer
Most SQL Server adminstrators prefer to change the port of a default instance from 1433 to something unused. This prevents hackers and malicious software from connecting to port 1433 and locating a SQL Server. Bottom line: everyone knows that the default SQL Server port is 1433 so, to create a secure server, change the port number

Other Websites We Offer
LearnCSharp.com
Don't Forget!
100% Money Back Guarantee
 
   
 
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!
 
1/6/2009 2:35:24 AM