如何在 SQLXML 中获取每个属性的名称、值和父元素名称？

DECLARE @xml XML
SET @xml = '<root>
                <parent id="1">
                    <child1>Value 1</child1>
                    <child2>Value 2</child2>
                </parent>
                <parent id="2">
                    <child1>Value 3</child1>
                    <child2>Value 4</child2>
                </parent>
            </root>'

SELECT *
INTO #xmlData
FROM OPENXML(@xml, '/root/parent', 2)
WITH (
    id INT '@id',
    child1 VARCHAR(50) 'child1',
    child2 VARCHAR(50) 'child2'
)

SELECT 
    c1.[text()] AS AttributeName,
    c1.value('.', 'VARCHAR(50)') AS AttributeValue,
    p1.value('local-name(..)', 'VARCHAR(50)') AS ParentElementName
FROM #xmlData
CROSS APPLY xmlData.nodes('//@*') AS t1(c1)
CROSS APPLY xmlData.nodes('.') AS t2(p1)