Posts on FOR XML


Here are a bunch of links explaining FOR XML. It covers some FOR XML EXPLICIT functionality and focuses on the new capabilities in SQL Server 2005.



  1. FOR XML EXPLICIT or the “Query from Hell“ in SQL Server 2005: A less likely encounter
  2. Moving FOR XML EXPLICIT to the new PATH mode:


  3. “What’s New in FOR XML in Microsoft SQL Server 2005“ is available on the MSDN XML DevCenter

[Note: this entry has been updated with link 3 on 2004-06-10]

Comments (5)

  1. Broken Links says:

    Links to the "sqljunkies" web site are broken and re-directing to nowhere important. This is a pretty bad error seeing as how you're the only person to ever write about this feature, according to Google anyway.

    1. MRys says:

      Unfortunately sqljunkies got bought and the content disappeared… 🙁