多次插入后获取插入的选定行的ID[重复]

你在找什么

CREATE TABLE T1(
  Col1 INT IDENTITY(1, 1),
  Col2 INT,
  Col3 INT
);

CREATE TABLE T2(
  Col1 INT IDENTITY(1, 1),
  Col2 INT,
  Col3 INT
);

INSERT INTO T2(Col2, Col3) VALUES
(11,  150),
(12,  151),
(15,  152);

DECLARE @TT TABLE (ID INT, Col2 INT);

SET IDENTITY_INSERT T1 ON;

INSERT INTO T1 (Col1, Col2, Col3)
OUTPUT INSERTED.Col1,
       INSERTED.Col2
INTO @TT (ID, Col2)
SELECT Col1,
       Col2,
       Col3
FROM T2;

SELECT *
FROM @TT;

SET IDENTITY_INSERT T1 OFF;

Demo