本文介绍了SQL Server for xml path 添加属性和值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想创建一个包含属性和值的 xml 节点.
I want to create an xml node that contains attributes as well as values.
示例:
<mynode attr1="hello">world</mynode>我明白
SELECT 'hello' as '@attr1'至少创建一个 mynode,但是如何附加world"呢?
creates at least mynode, but how to attach "world" then?
我试过了
SELECT 'world' as 'mynode/[@attr1=hello]'但是没有用
推荐答案这是一个基本的例子:
SELECT ( SELECT 'White' AS Color1, 'Blue' AS Color2, 'Black' AS Color3, 'Light' AS 'Color4/@Special', 'Green' AS Color4, 'Red' AS Color5 FOR XML PATH('Colors'), TYPE ), ( SELECT 'Apple' AS Fruits1, 'Pineapple' AS Fruits2, 'Grapes' AS Fruits3, 'Melon' AS Fruits4 FOR XML PATH('Fruits'), TYPE ) FOR XML PATH(''), ROOT('SampleXML')有关更多信息,您可以访问此页面 SQL SERVER – 使用 T-SQL 创建 XML 文件的简单示例
Please, for more information you can visit this page SQL SERVER – Simple Example of Creating XML File Using T-SQL
更多推荐
SQL Server for xml path 添加属性和值
发布评论