将XML导入SQL Server

<?xml version="1.0" encoding="UTF-8"?><Customers>
 <Customer>
   <CustomerID>1</CustomerID>
   <FirstName>John</FirstName>
    <LastName>Doe</LastName>
   <Email>john.doe@example.com</Email>
  </Customer>
 <Customer>
   <CustomerID>2</CustomerID>
   <FirstName>Jane</FirstName>
    <LastName>Doe</LastName>
   <Email>jane.doe@example.com</Email>
  </Customer>
</Customers>

CREATE TABLE Customers (
  CustomerID INT PRIMARY KEY,
  FirstName NVARCHAR(50),
  LastName NVARCHAR(50),
  Email NVARCHAR(100)
);

INSERT INTO Customers (CustomerID, FirstName, LastName, Email)
SELECT
  CustomerID = x.value('CustomerID[1]', 'INT'),
  FirstName = x.value('FirstName[1]', 'NVARCHAR(50)'),
  LastName = x.value('LastName[1]', 'NVARCHAR(50)'),
  Email = x.value('Email[1]', 'NVARCHAR(100)')
FROM OPENROWSET(
  BULK 'C:\path\to\customers.xml',
  SINGLE_BLOB
) AS x(xmlData);

INSERT INTO Customers (CustomerID, FirstName, LastName, Email)
SELECT
  CustomerID = x.value('CustomerID[1]', 'INT'),
  FirstName = x.value('FirstName[1]', 'NVARCHAR(50)'),
  LastName = x.value('LastName[1]', 'NVARCHAR(50)'),
  Email = x.value('Email[1]', 'NVARCHAR(100)')
FROM (
  SELECT CAST(xmlData AS XML)
  FROM OPENROWSET(
    BULK 'C:\path\to\customers.xml',
    SINGLE_BLOB
  ) AS x(xmlData)
) AS T(x);

SELECT * FROM Customers;