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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2006-11-21 : 03:49:43
|
| Can I generate an XML document from SQL Server 2000 and save that document to a specified location?I know you can generate XML by using a statement such as 'SELECT * FROM table1 FOR XML AUTO'but can I save XML generated to a file for future use (eg. to read into a web page)?Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-21 : 09:34:25
|
| Use ADO or ADO.NET or whatever data access mechanism your web development environment uses to get the XML from SQL Server just like it would get the data from any regular query. There's no need to save it to a file first. |
 |
|
|
|
|
|
XML question!