请问如何才能产生这样格式的xml文件呢??在线等,比较急。。。。。
我是这样做的:
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>