問題描述
我有這個(gè)查詢
WITH XMLNAMESPACES(DEFAULT 'https://tribunet.hacienda.go.cr /docs/esquemas/2017/v4.2/facturaElectronica'
,'http://www.w3.org/2001/XMLSchema' AS xsd
,'http://www.w3.org/2001/XMLSchema-instance' AS xsi)
SELECT 1 AS [id]
,0 AS [pass]
(
/*Others*/
SELECT
OT.OTH_MESSAGE as Others
FROM [crdx_COREDev1].[dbo].[OTH_OTHERS] as OT
where
OT.OTH_ID=E.OTH_ID
fOR XML PATH ('Others'), type
)
,0 AS [CONSECUTIVE]
FOR XML PATH('FE');
這會(huì)生成這個(gè) XML
<FE xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2 /facturaElectronica"> <- CHANGE 2
<id>1</id>
<pass>0</pass>
<CONSECUTIVE>0</CONSECUTIVE>
<Others xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2 /facturaElectronica">
<MESSAGE>MESSAGE</MESSAGE>
</Others>
</FE>
現(xiàn)在我的問題:我只希望
Now my question: I would like only <FE> to show the namespaces, but - as you see in the xml - that declarations appear also in <Others>. How can I limit this to <FE>?
推薦答案
這是一個(gè)令人討厭且眾所周知的問題，每當(dāng)您在 FOR XML 查詢中使用與嵌套子查詢相關(guān)的命名空間時(shí)，就會(huì)發(fā)生此問題...
This is an annoying and well known issue and occurs whenever you use namespaces in connection with nested sub-queries in FOR XML queries...
連接問題已存在 10 多年 - 直到最近消失.
There has been a connect issue for more than 10 years - until it disappaered recently.
值得一提的是，這些重復(fù)的命名空間聲明并沒有錯(cuò)，只是讓您的 XML 變得臃腫.它可能會(huì)與(以)嚴(yán)格的模式驗(yàn)證相沖突.
It is important to mention, that these repeated namespace declarations are not wrong, just bloating your XML. And it can collide with (to) strict schema validations.
沒有好的解決方案，只有解決方法:
No good solution, just workarounds:
- 創(chuàng)建沒有命名空間的內(nèi)部 XML 并在字符串基礎(chǔ)上添加包裝節(jié)點(diǎn)，或
- 將命名空間創(chuàng)建為普通屬性(但未命名為
xmlns)并使用REPLACE更改名稱.
- Create the inner XML without the namespace and add the wrapping node on string base, or
- Create the namespaces as normal attributes (but not named
xmlns) and useREPLACEto change the names.
兩種解決方法都需要轉(zhuǎn)換為 NVARCHAR(MAX) 并返回到 XML.
Both workarounds need a conversion to NVARCHAR(MAX) and back to XML.
我真的不知道，為什么要以這種方式實(shí)現(xiàn)...
I really have no idea, why this was implemented this way...
找一些相關(guān)的例子
- 此處
- 和此處
- 和此處
- 和此處
注意:
xmlns="https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2 /facturaElectronica">
您正在使用帶空格的命名空間 URL.這是不允許的...
You are using namespace URLs with blanks. This is not allowed...
這篇關(guān)于將 xml-namespaces 限制為僅主根的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！