版本不是问题:http://technet.microsoft.com/zh-cn/library/ms143761%28SQL.90%29.aspx 试试以下代码:USE AdventureWorks; SELECT OH.SalesOrderID,OrderDate,CustomerID,ContactID,OrderQty,UnitPrice FROM Sales.SalesOrderDetail AS OD JOIN Sales.SalesOrderHeader AS OH ON OD.SalesOrderID = OH.SalesOrderID WHERE OrderDate BETWEEN '20040710' AND '20040711' FOR XML RAW('SalesOrderInfo'),ELEMENTS,ROOT('QueryResult')
或者你没有安装完全?
试试以下代码:USE AdventureWorks;
SELECT OH.SalesOrderID,OrderDate,CustomerID,ContactID,OrderQty,UnitPrice
FROM Sales.SalesOrderDetail AS OD
JOIN Sales.SalesOrderHeader AS OH
ON OD.SalesOrderID = OH.SalesOrderID
WHERE OrderDate BETWEEN '20040710' AND '20040711'
FOR XML RAW('SalesOrderInfo'),ELEMENTS,ROOT('QueryResult')