How can I save XML result set in a file using query analyzer

[essa2000]

Dears ;

I am trying to use Select * from authors FOR XML AUTO to generate a XML result set now I want to same this result set in one XML file. How can I do that ! Then I'll populate data in my combo or grid.

Thanks.
Essa

Muhammad Essa Mughal
Software Engineer
iLogic Inc.

 

[JoeSack]

Hi,

You could use the sp_makewebtask system stored procedure.

sp_makewebtask @outputfile = 'c:\temp\authors.xml',
@query='select * from leaders for xml auto',
@templatefile = 'c:\temp\template.tpl'

The template file, to quote from BOL, &quot;contains information on the formatting characteristics of HTML documents and contains the tag <%insert_data_here%>, which indicates the position to which the query results will be added in an HTML table. templatefile is nvarchar(255).&quot;

Template file formats are reviewed within the &quot;sp_makewebtask&quot; further in BOL.

This is one method to export a file directly from Query Analyzer. Of course, you could also use a DTS export.



Best Regards,
Joseph Sack,

http://www.JoeSack.com

Author of &quot;SQL Server 2000 Fast Answers for DBAs and Developers&quot;.