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  

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:
The command-line command "netstat" can show you active connections, TCP port usage, network statistics and more
SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration
You can use the "PSS Service Center Labs - 2004" to see how Microsoft Product Support Services works with SQL Server problems. Check out Microsoft's Download page and search for "PSS Service Center Labs - 2004" for more. Careful - geeks only!

Other Websites We Offer
LearnIntegrationServices.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!
 
8/28/2008 3:08:01 AM