无法将"WITH XMLNAMESPACES ... FOR XML PATH"的输出设置为变量? [英] Can't set output of 'WITH XMLNAMESPACES...FOR XML PATH' to a variable?
本文介绍了无法将"WITH XMLNAMESPACES ... FOR XML PATH"的输出设置为变量?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个类似以下的查询:
I have a query like the following:
;WITH XMLNAMESPACES ( DEFAULT 'http://www.somewhere.com')
SELECT ( 'SOMETHING' )
FOR XML PATH('RootNode'), TYPE
运行此程序效果很好.但是,当我尝试将XML输出设置为这样的变量时,会遇到麻烦:
Running this works fine. However, I run into troubles when I try to set the XML output to a variable like this:
DECLARE @MYXML AS XML
SELECT @MYXML = (
;WITH XMLNAMESPACES ( DEFAULT 'http://www.somewhere.com')
SELECT ( 'SOMETHING' )
FOR XML PATH('RootNode'), TYPE
)
这只是给我一个语法错误:-(关于如何完成此操作的任何想法将不胜感激.
This just give me a syntax error :-( Any ideas on how to accomplish this would be greatly appreciated.
推荐答案
DECLARE @MYXML AS XML
;WITH XMLNAMESPACES ( DEFAULT 'http://www.somewhere.com')
SELECT @MYXML = (
SELECT ( 'SOMETHING' )
FOR XML PATH('RootNode'), TYPE)
这篇关于无法将"WITH XMLNAMESPACES ... FOR XML PATH"的输出设置为变量?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文