JOIN Products ON Categories.CategoryID = Products.CategoryID  and ProductID <4

WHERE Categories.CategoryID <3  FOR XML AUTO, ELEMENTS

返回结果：

<Categories>

         <CategoryID>1</CategoryID>

         <Products>

<ProductID>1</ProductID>

                   <ProductName>Chai</ProductName>

         </Products>

         <Products>

                   <ProductID>2</ProductID>

                   <ProductName>Chang</ProductName>

         </Products>

</Categories>

<Categories>

         <CategoryID>2</CategoryID>

         <Products>

                   <ProductID>3</ProductID>

                   <ProductName>Aniseed Syrup</ProductName>

         </Products>

</Categories>

4．检索对二进制数据的XPath引用

这是对二进制数据的操作，

查询语句：

SELECT CategoryID,

Picture

FROM Categories

WHERE CategoryID = 1

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>