<ProductID>4</ProductID> <ProductName>Chef Anton's Cajun Seasoning</ProductName> </Product> </Category> <Category Name="Beverages"> <Product> <ProductID>1</ProductID> <ProductName>Chai</ProductName> </Product> <Product><ProductID>2</ProductID> <ProductName>Chang</ProductName> </Product> </Category> 3> 使用xmltext指令 该指令是用来处理包含xml片断内容的数据列,没找到现成的表结构和数据进行测试,所以就在Categories表中增加了XmlData列名,类型为nvarchar,默认值设置为“<customData email="xxx(at)hotmail.com" />”。 查询语句: SELECT 1 AS Tag,NULL AS Parent, CategoryID AS [Category!1!ID], XmlData AS [Category!1!CustomData!xmltext] FROM Categories WHERE CategoryID = 8 FOR XML EXPLICIT 返回结果: <Category ID="8"><CustomData email="xxx(at)hotmail.com"/></Category> 查询语句: SELECT 1 AS Tag,NULL AS Parent, << 上一页 [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] ... 下一页 >> |