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>
<ProductID>2</ProductID>
<ProductName>Chang</ProductName>
</Categories>
<CategoryID>2</CategoryID>
<ProductID>3</ProductID>
<ProductName>Aniseed Syrup</ProductName>
4.检索对二进制数据的XPath引用
这是对二进制数据的操作,
查询语句:
SELECT CategoryID,
Picture
FROM Categories
WHERE CategoryID = 1
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >>
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18