You are here:
SQL Server 2012 - Microsoft's latest database engine SQL Server 2012 - Microsoft's latest database engine

SQL XML – FOR XML AUTO

Currently working on restructuring some google sitemaps for my client. Instead of the usual query, loop, output process for a ColdFusion XML manipulation based task, I decided to get SQL server to do the work for me. Using FOR XML AUTO, ELEMENTS at the bottom of my query, I can get SQL to return the results of my query in an XML format, return it and the rest is ColdFusion work. Take a look at some articles on this topic at ...

SQL Server 2000 Meets XML @ COLDFUSION DEVELOPER’S JOURNAL

EasyCFM.COM ColdFusion Tutorial: FOR XML and Cold Fusion

Wayne Graham’s Blog: Getting XML from MSSQL Server