1) Generate a file with the text-editor like:
<%begindetail%>
<%insert_data_here%>
<%enddetail%>
Save it as c:\temp\template.tpl
2) Open Query Analyzer and type:
sp_makewebtask @outputfile = 'c:\temp\myxmlfile.xml',
@query = 'select * from sysobjects for xml auto',
@templatefile = 'c:\temp\template.tpl'
The result is a XML-File!
More ^
No comments:
Post a Comment