请问如何才能产生这样格式的xml文件呢？？在线等，比较急。。。。。

[csdnye]

我是这样做的：
declare @sql nvarchar(4000)
use northwind
set @sql='bcp "SELECT 1 as Tag, NULL as Parent,CustomerID as [Customer!1!CustomerID!element] FROM northwind.dbo.Customers FOR XML EXPLICIT" queryout h:\Employees.xml -c -q -S"ye" -U"sa" -P"9933"'
exec master..xp_cmdshell @sql
但是得到的只是
<Customer>
<CustomerID>ALFKI</CustomerID>
</Customer>
<Customer><CustomerID>ANATR</CustomerID>
</Customer><Customer><CustomerID>ANTON</CustomerID></Customer>

[csdnye]

我想得到的是
<boot>
<Customer>
<CustomerID>ALFKI</CustomerID>
</Customer>
<Customer>
<CustomerID>ANATR</CustomerID>
</Customer>
<Customer>
<CustomerID>ANTON</CustomerID>
</Customer>
</boot>
因为在前台总是说我又多个根元素。

[TaoGeGe]

很少接觸
up

[pengdali]

建立例子模版：在C:\下新建内容为下面的一“模版.htp”
<boot><%insert_data_here%></boot>
exec sp_makewebtask 'c:\模版实例.html','SELECT 1 as Tag, NULL as Parent,CustomerID as [Customer!1!CustomerID!element] FROM northwind.dbo.Customers FOR XML EXPLICIT',@templatefile='h:\Employees.xml',@lastupdated=0,@resultstitle=' ',@charset='gb2312'

[leimin]

你可以通过模板来实现，比如你可以建立一个getcustomer.xml文件。
<root xmlns:sql='urn:schemas-microsoft-com:xml-sql'>
<sql:query>
SELECT 1 as Tag, NULL as Parent,CustomerID as [Customer!1!CustomerID!element] FROM northwind.dbo.Customers FOR XML EXPLICIT
</sql:query>
</root>

这样你就可以通过HTTP调用该XML文件返回有根元素的XML文件。

[jiangchuandong]

up

[softye]

up