在sql server中通过xml插入多行。

DECLARE @xmlData XML;
SET @xmlData = '
<rows>
  <row>
    <column1>Value1</column1>
    <column2>Value2</column2>
  </row>
  <row>
    <column1>Value3</column1>
    <column2>Value4</column2>
  </row>
</rows>';

DECLARE @idoc INT;
EXEC sp_xml_preparedocument @idoc OUTPUT, @xmlData;

INSERT INTO YourTable (Column1, Column2)
SELECT column1, column2
FROM OPENXML(@idoc, '/rows/row', 2)
WITH (
  column1 VARCHAR(50),
  column2 VARCHAR(50)
);

EXEC sp_xml_removedocument @idoc;