如何在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
    PersonData.value('(name)[1]', 'varchar(50)') AS Name,
    PersonData.value('(age)[1]', 'int') AS Age
FROM
    @xmlData.nodes('/root/person') AS T(PersonData);