Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL 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:
Keyboard Shortcut for SQL Server Management Studio: CTRL+R hides/displays the results pane
Keyboard Shortcut for SQL Server Management Studio: CTRL+O opens a file
Helpful Keyboard Shortcuts: "Windows key" + "F" brings up the Search window

Other Websites We Offer
LearnVBProgramming.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/8/2009 2:59:09 PM