SQL Server:从XML数据输出中的任意节点选择特定值-已回答

DECLARE @xmlData XML = '<root>
                          <person>
                            <name>John</name>
                            <age>30</age>
                          </person>
                          <person>
                            <name>Jane</name>
                            <age>25</age>
                          </person>
                        </root>';

SELECT
    PersonName = x.value('(name)[1]', 'varchar(50)'),
    PersonAge = x.value('(age)[1]', 'int')
FROM
    @xmlData.nodes('/root/person') AS t(x);