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.
| Author |
Topic |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2007-04-04 : 07:49:34
|
| Hi all,Can someone please help.I am trying to export a table in SQL to XML.From My readings. I need to create an XML Schema that will be used to define the finished XML from the Table.I have used Stylus Studio to create an XML from the table and then an XML Schema from the XML..My question is... I now have a table in SQL and an XML schema to create an XML but how do I run this in SQL 2000 and then schedule it to run every day.I think I need to Use xpath query that creates the xml but I don't know where to start this. Can you please help.Ray.. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-04-04 : 14:31:17
|
| Take a look herehttp://www.perfectxml.com/articles/XML/ExportSQLXML.asp |
 |
|
|
|
|
|
XML Schema in SQL