如何形状重命名 sql.xml 查询 xml 元素
我有以下查询
insert @p(target,type,val,[order])
select "/session/verbs/put[@field='orno.f']",'string',141527,1
union select "/session/verbs/put[@field='orno.t']","string",141527,2
union select "/session/verbs/put[@field='orno.t']","string",141527,2
union select "/session/verbs/put[@field='comp.f']","string",000,2
union select "/session/verbs/put[@field='comp.t']","string",999,2.1
union select "/session/verbs/setreport/parameter[@name='device']","string",105,3
set quoted_identifier on
SELECT (SELECT target, type
FROM @p
FOR XML RAW, TYPE,ROOT('session')).query('/*');
并返回
<session>
<row target="/session/verbs/put[@field='comp.f']" type="string" />
<row target="/session/verbs/put[@field='comp.t']" type="string" />
<row target="/session/verbs/put[@field='orno.f']" type="string" />
<row target="/session/verbs/put[@field='orno.t']" type="string" />
<row target="/session/verbs/setreport/parameter[@name='device']" type="string" />
如何修改查询以将
重命名为
I have the following query
insert @p(target,type,val,[order])
select "/session/verbs/put[@field='orno.f']",'string',141527,1
union select "/session/verbs/put[@field='orno.t']","string",141527,2
union select "/session/verbs/put[@field='orno.t']","string",141527,2
union select "/session/verbs/put[@field='comp.f']","string",000,2
union select "/session/verbs/put[@field='comp.t']","string",999,2.1
union select "/session/verbs/setreport/parameter[@name='device']","string",105,3
set quoted_identifier on
SELECT (SELECT target, type
FROM @p
FOR XML RAW, TYPE,ROOT('session')).query('/*');
and this returns
<session>
<row target="/session/verbs/put[@field='comp.f']" type="string" />
<row target="/session/verbs/put[@field='comp.t']" type="string" />
<row target="/session/verbs/put[@field='orno.f']" type="string" />
<row target="/session/verbs/put[@field='orno.t']" type="string" />
<row target="/session/verbs/setreport/parameter[@name='device']" type="string" />
How can I modify the query to rename <row>
to <parameter>
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
如果您使用 SQL Server 2008 (R2),您可以在 RAW 指令后传递您的参数名称:
if you user SQL Server 2008 (R2) you may pass your parameter name after RAW derective: