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 |
|
donar
Starting Member
22 Posts |
 Posted - 2005-01-28 : 10:35:13
|
| Hi, thereI am now trying to use SQL Server 2000 to generate an xml file,but whenever I execute the "select * from table for xml auto|raw|explicit", it will give me an auto generated code at the beginning , like "XML_F52E2B61-18A1-11d1-B105-00805F49916B", how can I get rid of it?And if the result xml file is too long, sql server will trim the xml file in one line, even i use "results to file", it will look like this: "<themekey>argillites</themekey><themekey>arsenic</themekey><themekey>arsenopyr"or I can change I many charactor can be displayed in one line, but it will be very very long, i do not know how to solve this problem.Hope I express myself clearly.And thank for you guys' help in advance. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-28 : 19:12:53
|
| Are you using Query Analyzer to export your data ?It's not really designed to be run as part of your application. You should write some code to grab the XML and put it in a file.Damian |
 |
|
|
|
|
|
how to get rid of XML generated code