Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Export XML From MSSQL 2000

Author  Topic 

giovi2002
Starting Member

46 Posts

Posted - 2005-07-20 : 13:09:02
Goal: Easily export xml, with the possibility to merge a template which defines the header and the body layout of the xml
Question: what's your preferred way to do that?

Example, I have a table
Number Question Answer
1 5 3
2 6 4

My Xml should contain a header with the sending organisation, the number of records etcetera. My records (table headers) will be renamed to the following tags: nummer, vraag, antwoord

I guess, you can define the body tags in the template..?




   

- Advertisement -