DECLARE @xml AS XML
SET @xml = CAST('<codes><pcc>DFC</pcc><pcc>MAI</pcc><pcc>PFS</pcc></codes>' AS XML)
SELECT pcc.value('pcc[1]', 'varchar(max)') AS [ColumnTest]
FROM @xml.nodes('/codes') results ( pcc )
我有这个非常简单的xml,我试图将<pcc>
节点中的所有数据拉到结果集中。我读到我要使用交叉应用,但到目前为止,我的努力失败了。
提前感谢。
DECLARE @xml AS XML
SET @xml = CAST('<codes><pcc>DFC</pcc><pcc>MAI</pcc><pcc>PFS</pcc></codes>' AS XML)
SELECT pcc.value('.', 'varchar(max)') AS [ColumnTest]
FROM @xml.nodes('/codes/pcc') results ( pcc )