What are my options for returning XML to a client application from SQL Server? I have an XSD that I want to apply to some data, but don't want to build the XML from a result set if I can avoid it.
asked Oct 19 '09 at 11:11 AM in Default
Steve Jones - Editor ♦♦
This article at Simple-Talk goes over XML pretty well. You should be able to extrapolate your answer from there:
You can also get lots of help from the MSDN forums on XML:
And for brevety's sake, here's the BOL link to XML in SQL 2005