|
Home > Archive > MS SQL XML > September 2005 > Which method should I use to export XML?
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 |
Which method should I use to export XML?
|
|
| Barry van Dijk 2005-09-05, 11:45 am |
| I've googled around the net and found multiple solutions to create XML. But
I'm totally confused about what method I shoud use...
Can someone please point me in the right direction:
I've got: Access 2000 project (Front End), SQL 2000 (Back End)
I've got a stored proc which returns all data I need. Now I need to poor it
in a XML format my client wishes, which looks like this (it's for invoices):
<Invoices>
<Invoice>
<Header>
</Header>
<Detail>
<Detail_cost>
</Detail_cost>
<Detail>
<Totals>
</Totals>
</Invoice>
</Invoices>
| |
| Barry van Dijk 2005-09-06, 7:23 am |
| To complete the question:
The export to XML can be done from SQL server itself or a communications PC,
I'd prefer no to do this from the client application...
| |
| Bertan ARI [MSFT] 2005-09-07, 8:24 pm |
| You may use FOR XML or XPath over Annotated XSD to export Xml data from SQL
Server.
--
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry van Dijk" < BarryvanDijk@discuss
ions.microsoft.com> wrote in message
news:909BF0DF-D280-4E0A-AD1B- 910E2636FBED@microso
ft.com...
> I've googled around the net and found multiple solutions to create XML.
> But
> I'm totally confused about what method I shoud use...
>
> Can someone please point me in the right direction:
>
> I've got: Access 2000 project (Front End), SQL 2000 (Back End)
>
> I've got a stored proc which returns all data I need. Now I need to poor
> it
> in a XML format my client wishes, which looks like this (it's for
> invoices):
>
> <Invoices>
> <Invoice>
> <Header>
> </Header>
> <Detail>
> <Detail_cost>
> </Detail_cost>
> <Detail>
> <Totals>
> </Totals>
> </Invoice>
> </Invoices>
|
|
|
|
|