How can I save the output of query(on SQL 2000) as an .xml file locally onthe SQL box ? I am using the FOR XML clause and getting a single recordback with a single column, but how do I now save this to an xml file ? Soin the end, I'd like to have a stored proc to execute that will drop thedata in one or more xml files locally (say root of c:\) for another processto pick up and distribute.
How to save output of SQL 2000 query as an .xml file locally
- Thread starter admin
- Start date