The FOR XML clause was new in SQL 2000.
>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
--sb--