如何用SQL Server从xml中获取嵌套对象列表？

DECLARE @xmlData XML = '<root>
                          <objects>
                            <object>
                              <id>1</id>
                              <name>Object 1</name>
                            </object>
                            <object>
                              <id>2</id>
                              <name>Object 2</name>
                            </object>
                          </objects>
                        </root>';

SELECT
    ObjectNode.value('(id)[1]', 'int') AS id,
    ObjectNode.value('(name)[1]', 'varchar(50)') AS name
FROM
    @xmlData.nodes('/root/objects/object') AS T(ObjectNode);

id  | name
----|---------
1   | Object 1
2   | Object 2