使用不起作用的SQL导入XML中的字段

<employees>
  <employee>
    <id>1</id>
    <name>John Doe</name>
    <age>30</age>
  </employee>
  <employee>
    <id>2</id>
    <name>Jane Smith</name>
    <age>25</age>
  </employee>
</employees>

DECLARE @xml XML
SET @xml = '<employees>
              <employee>
                <id>1</id>
                <name>John Doe</name>
                <age>30</age>
              </employee>
              <employee>
                <id>2</id>
                <name>Jane Smith</name>
                <age>25</age>
              </employee>
            </employees>'

DECLARE @hdoc INT
EXEC sp_xml_preparedocument @hdoc OUTPUT, @xml

INSERT INTO Employees (Id, Name, Age)
SELECT Id, Name, Age
FROM OPENXML(@hdoc, '/employees/employee', 2)
WITH (
  Id INT 'id',
  Name VARCHAR(50) 'name',
  Age INT 'age'
)

EXEC sp_xml_removedocument @hdoc