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'
不良格式的原因：
１）如果有中文，会变成乱码，并影响后面的元素标记．
如果直接从查询分析器把结果copy到XMLspy，不会乱码．
２）元素标记被截断换行．
