请问如何解决sql2000生成xml文件,被XMLspy认为有不良格式.
数据库结构:
create table ##Folder(
f_id int,
[name] nvarchar(20)
)
create table ##Placemark(
id int,
f_id int,
[name] nvarchar(200),
[description] nvarchar(4000)
)
create table ##point(
id int,
[coordinates] nvarchar(50)
)
输出语句:
exec master..xp_cmdshell 'bcp "select Folder.name,Placemark.name,Placemark.description,Point.coordinates from ##folder Folder inner join ##placemark Placemark on Folder.f_id=Placemark.f_id inner join ##point Point on Placemark.id=Point.id order by folder.name FOR XML AUTO, ELEMENTS" queryout "D:\a.xml" /U"sa" /P"" /c'
不良格式的原因:
1)如果有中文,会变成乱码,并影响后面的元素标记.
如果直接从查询分析器把结果copy到XMLspy,不会乱码.
2)元素标记被截断换行.