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

Introduction to the FOR XML Clause (Video Series)

Video Image Video Category: XML and SQL Server - FOR XML, SQLXML, MSXML, and More

Skill Level: 300 (Intermediate)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
The FOR XML extensions to the SELECT statement are actually quite simple to work with if you already know the intricate differences between them and the details about when to use each. This series of videos helps fill in any gaps you might have and helps answer questions like:
  • Should you use FOR XML AUTO or FOR XML PATH?
  • What's the difference between FOR XML EXPLICIT and FOR XML PATH?
  • When should I use the new TYPE directive?

and much more

Videos in this Series:


Miscellaneous Bits & Pieces:
Book You Should Probably Own: Joe Celko's "SQL Puzzles and Answers"
Performance Tip: In many instances temporary tables can be rewritten as table variables. Table variables are often faster and do not have the locking issues that temporary tables experience
Keyboard Shortcut for SQL Server Management Studio: Shift+F1 brings up the context-sensitive help in Books Online

Other Websites We Offer
LearnReportingServices.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!
 
11/19/2008 5:21:34 PM