From within Query Analyzer, does anyone know how to redirect the results of a stored procedure to an XML file?
I have a stored proc that returns 3 tables. What I’d like to do is type something along the lines of:
EXEC MyStoredProc @Parm1, @Parm2 OUTPUT TO C:\XMLResults.XML
There are new FOR XML clauses in SQL 2005, but from what I've seen, they seem to apply to individual SELECT statements.
I know that I can write a few lines of code in ADO.NET to do it. Just curious if I can do it within SQL Server.
Kevin