如何在storedprocedure中执行xmlnamespace? [英] How to execute xmlnamespace in storedprocedure?
本文介绍了如何在storedprocedure中执行xmlnamespace?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
i试图在下面的存储过程中执行xmlnamespace ,
但它说的是,
' XMLNAMESPACES'附近的语法不正确。
我的代码是:
INSERT #BrandData
WITH XMLNAMESPACES(' http://mch.com/IF002/SD/mch/I_mch' as ns0)
SELECT
数据。 value (' (昵称/ text())[1]',' VARCHAR(100)')AS昵称,
数据。 value (' (username / text())[1]',' VARCHAR(100)')AS用户名,
数据。 value (' (IsActive / text())[1]',' VARCHAR(4)')AS IsActi ve
FROM
@ xmldoc.nodes(' // ns0:mch_In /数据')AS BrandData(数据)
请给我一个解决方案 这
我尝试过:
如何在storedprocedure中执行xmlnamespace?
解决方案
我对此没有多少工作但是我相信你的订单声明是错误的。它应该像下面这样 -
WITH XMLNAMESPACES(' http://mch.com/IF002/SD/mch/I_mch' as ns0)
INSERT #BrandData
SELECT
Data.value(' (昵称/ text())[1]',' VARCHAR(100)') AS 昵称,
Data.value(' (username / text())[1]',< span class =code-string>' VARCHAR(100)') AS 用户名,
Data.value(' (IsActive / text())[1]', ' VARCHAR(4)') AS IsActive
FROM
@ xmldoc .nodes(' // ns0:mch_In / Data') AS BrandData(Data)
如果您还有问题,请试着告诉我。 :)
Hi all,
i have tried to execute xmlnamespace in the below storedprocedure,
but its saying that ,
Incorrect syntax near 'XMLNAMESPACES'.
My code is :
INSERT #BrandData
WITH XMLNAMESPACES('http://mch.com/IF002/SD/mch/I_mch' as ns0)
SELECT
Data.value('(nickname/text())[1]','VARCHAR(100)') AS nickname,
Data.value('(username/text())[1]','VARCHAR(100)') AS username,
Data.value('(IsActive/text())[1]','VARCHAR(4)') AS IsActive
FROM
@xmldoc.nodes('//ns0:mch_In/Data')AS BrandData (Data)
please drop me a solution for this
What I have tried:
how to execute xmlnamespace in storedprocedure?
解决方案
I haven't worked much on this but I belive your order statement is wrong. It should something like following-
WITH XMLNAMESPACES('http://mch.com/IF002/SD/mch/I_mch' as ns0) INSERT #BrandData SELECT Data.value('(nickname/text())[1]','VARCHAR(100)') AS nickname, Data.value('(username/text())[1]','VARCHAR(100)') AS username, Data.value('(IsActive/text())[1]','VARCHAR(4)') AS IsActive FROM @xmldoc.nodes('//ns0:mch_In/Data')AS BrandData (Data)
Please try and let me know if you still have issues. :)
这篇关于如何在storedprocedure中执行xmlnamespace?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文