FROM Categories
WHERE categoryID > 6 FOR XML EXPLICIT
2.連接查詢
在EXPLICIT模式下的多表連接查詢可能相對比較復雜些，先來看一個簡單的例子，
查詢語句：
SELECT 1 AS Tag,NULL AS Parent,
Categories.CategoryID AS [Category!1!ID],
Categories.CategoryName AS [Category!1!!element],
ProductID AS [Category!1!ProductID!element],
ProductName AS [Category!1!ProductName!element]
FROM Categories
JOIN Products ON Categories.CategoryID = Products.CategoryID AND ProductID <5
文章來源于領測軟件測試網 http://www.kjueaiud.com/
