Generate XML Files

[ralphwiggum]

Does anyone know how to use SQL server to generate XML files? I'm familiar with the xml functionality in SQL server such as OPENXML, XML through http, etc but I haven't found a way to simply generate an XML document. I'd like to be able to import XML documents in as well but I'll save that for later. Thanks in advance for any help you can provide.

 

[sunila7]

Have a look at FOR XML clause for SELECT statements. It works only for SQL server 2000 DB's

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_1hd8.asp

Sunil

 

[ralphwiggum]

Thanks for response, I've played with the FOR XML before and that is what got me thinking in the first place about this ;>. I want to be able to take what the FOR XML gives me in QA and have it save to an external XML file. Ideally this would be executed by a trigger on a table or possibly using a scheduled job. I know I could use an ActiveX script or vb to do it but I was hoping there was a purely SQL way of doing it. Thanks again for your help.