对于XML:使用单元格值创建元素 [英] For XML: create elements using cell values
本文介绍了对于XML:使用单元格值创建元素的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
如果有一个包含2列和2行值的sql表
[[" col1row1"," col2row1"],[" ; col1row2"," col2row2"]]。
将t-SQL与for xml一起使用
如何在单元格中创建xml值(不是列名)出现
作为元素?
例如:
< col1row1> col2row1< / col1row1>
< col1row2> col2row2< / col1row2>
谢谢,
slyi
Hi All,
If have a sql table with 2 columns and 2 rows with values
[["col1row1","col2row1"],["col1row2","col2row2"]].
Using t-SQL with "for xml"
How can i create a xml where the cell values (not column names) appear
as elements?
eg:
<col1row1>col2row1</col1row1>
<col1row2>col2row2</col1row2>
Thanks,
slyi
推荐答案
- 它可以完成,但请记住,你必须
- 自己逃避所有XML
>
创建表#test(
col1 varchar(8),
col2 varchar(8))
插入#test(col1,col2)
值(''col1row1'',''col2row1'')
插入#test(col1,col2)
值(''col1row2'',''col2row2'')
sele ct 1 as Tag,
null as Parent,
''<''+ col1 +''>''+ col2 +''< /''+ col1 + ''>''作为[TestNode!1 !! xml]
来自#test
按标签订购,[TestNode!1 !! xml]
for xml explicit
drop table #test
-- It can be done, but remember that you will have to
-- escape all the XML yourself
create table #test(
col1 varchar(8),
col2 varchar(8))
insert into #test(col1,col2)
values (''col1row1'',''col2row1'')
insert into #test(col1,col2)
values (''col1row2'',''col2row2'')
select 1 as Tag,
null as Parent,
''<''+col1+''>''+col2+''</''+col1+''>'' as [TestNode!1!!xml]
from #test
order by Tag,[TestNode!1!!xml]
for xml explicit
drop table #test
非常感谢那就是什么我需要知道
Thanks thats exactly what i needed to know
仔细检查一下,这不会有效。
< TestNode>< col1row1> ; col2row1< / col1row1>< / TestNode>
< TestNode>< col1row2> col2row2< / col1row2>< / TestNode>
虽然我需要类似的东西
< TestNode>
< col1row1> col2row1< / col1row1>
< col1row2> col2row2< / col1row2>
< / TestNode>
On closer examination this wont work it gives
<TestNode><col1row1>col2row1</col1row1></TestNode>
<TestNode><col1row2>col2row2</col1row2></TestNode>
while i need something like
<TestNode>
<col1row1>col2row1</col1row1>
<col1row2>col2row2</col1row2>
</TestNode>
这篇关于对于XML:使用单元格值创建元素的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文