CategoryID  [Category!1!ID],

CategoryName  [Category!1!Name],

Description  [Category!1]

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

WHERE Categories.CategoryID < 3 FOR XML EXPLICIT

返回结果：

<Category ID="1">

         Beverages

         <ProductID>1</ProductID>

         <ProductName>Chai</ProductName>

</Category>

<Category ID="1">

         Beverages

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20]  ...  下一页 >>