Write XML File Using SQL Server 2000
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Dear Sir Please tell me how can I write XML file using SQL? (I need the syntax for the query which perform this task) Thank You MNG
-
Dear Sir Please tell me how can I write XML file using SQL? (I need the syntax for the query which perform this task) Thank You MNG
You can use FOR XML clause to retrieve result in XML format. For example:
SELECT TOP 10 * FROM sysobjects FOR XML AUTO, ELEMENTSBut I don't know if it is possible to write this result straight to a file.