How do generate XML doc from SQL Server data?
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Abc_Def
Posted On:   Thursday, October 18, 2001 07:58 AM

How can I extract data from SQL Server table into an XML file?

Also, if anyone knows free but good XML authoring tools, can you pls. pass on the info?

Re: How do generate XML doc from SQL Server data?

Posted By:   Bozidar_Dangubic  
Posted On:   Thursday, October 18, 2001 08:08 AM

I believe in SQL server you can do something like "SELECT * from table as XML" which will return DOM object which you can then serialize into a file. I do not use SQL Server but I read that this is a feature of SQL Server 2000.
About | Sitemap | Contact