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:
Tips and Tricks: Create your own customized MMCs (Microsoft Management Console) for easier administration. Go to the command-line and run the command "MMC" to launch the MMC window. All that's left is for you to add in the various snap-ins you want to work with and then save the file
Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+L converts text to lowercase
Performance Tip: If your stored procedures use temporary tables or table variables create these as the first line(s) of code in your stored procedure. This helps minimize/prevent recompiles which allows SQL Server to cache the procedure's execution plan for maximum reuse

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!
 
8/28/2008 3:00:03 AM