我的 XML 結構看起來像這樣
從 XML 我需要從KeyValuePair/Value集合中選擇節點HHQuoteData
我下面的代碼不回傳任何資料。我的代碼有什么問題？
SELECT
k.kv.query('KeyValuePair/Value/HHQuoteData')
FROM DeclinedQuote.RequestLogXMLsToProcess aph
CROSS APPLY [PayloadXML].nodes('/server/requests/Session.setDocumentRq/session/data/policy/AdditionalData') A (ad)
CROSS APPLY a.ad.nodes('KeyValuePair') k (kv)
WHERE k.kv.exist('(/Value[contains(.,"HHQuoteData")])') = 1
示例 xml
uj5u.com熱心網友回復：
@lptr 在評論中的另一個答案......
with xmlnamespaces
(
'http://www.fc.com/quote/request/' as r,
'http://www.fc.com/quote/' as q,
'http://www.fc.com/householdaggregator/request' as hr
)
select a.d.query('.')
from @x.nodes('server/requests/Session.setDocumentRq/session/data/policy/r:AdditionalData/r:KeyValuePair/q:Value/hr:HHQuoteData') as a(d);
with xmlnamespaces('http://www.fc.com/quote/request/' as r, 'http://www.fc.com/quote/' as q)
select a.d.query('.')
from @x.nodes('server/requests/Session.setDocumentRq/session/data/policy/r:AdditionalData/r:KeyValuePair/q:Value/*:HHQuoteData') as a(d);
select a.d.query('.')
from @x.nodes('server/requests/Session.setDocumentRq/session/data/policy/*:AdditionalData/*:KeyValuePair/*:Value/*:HHQuoteData') as a(d);
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/492123.html