|
Home > Archive > MS SQL XML > October 2005 > Exporting to a xml file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Exporting to a xml file
|
|
|
| Dear all,
I've got a table of which I would need obtain a XML file. How do I such
thing?
I mean, instead of to obtain a .DAT or .CSV from that table as it customary,
a xml.
Any advice or though woud be greatly.
Regards,
| |
| Michael Rys [MSFT] 2005-10-27, 9:25 am |
| Are you using SQL Server 2005 or SQL Server 2000? Can it be manual or does
it need to be programmatic?
I would look into using FOR XML to generate the XML from the table and use
ADO or ADO.Net to take the result stream (use the stream interface, not the
rowset interface) to load a file.
Best regards
Michael
"Enric" <Enric@discussions.microsoft.com> wrote in message
news:30EBA615-16A1-4751-8358- A32030FC2CCE@microso
ft.com...
> Dear all,
>
> I've got a table of which I would need obtain a XML file. How do I such
> thing?
> I mean, instead of to obtain a .DAT or .CSV from that table as it
> customary,
> a xml.
>
> Any advice or though woud be greatly.
>
> Regards,
|
|
|
|
|