CategoryID AS [Category!1!ID], XmlData AS [Category!1!!xmltext] FROM Categories WHERE categoryID = 8 FOR XML EXPLICIT 返回结果: <Category ID="8" email="xxx(at)hotmail.com"></Category> 4> 使用cdata指令 使用该指令可以创建CDATA节防止一些字符数据被xml解析器。 查询语句: SELECT 1 AS Tag,NULL AS Parent, CategoryID AS [Category!1!ID], XmlData AS [Category!1!!cdata] FROM Categories WHERE categoryID = 6 FOR XML EXPLICIT 返回结果: <Category ID="6"><![CDATA[<customData email="xxx(at)hotmail.com" />]]></Category> 5> 使用ID、IDREF和IDREFS指令以及XMLDATA选项 由于这里只能返回XDR构架,不支持XSD架构的检索,我就只给出一个例子, 查询语句: SELECT 1 AS Tag,NULL AS Parent, CategoryID AS [Category!1!ID!ID], CategoryName AS [Category!1!N << 上一页 [21] [22] [23] [24] 下一页 |