SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE #temp(col VARCHAR(100));
INSERT INTO #temp(col)
VALUES ('A'), ('B'), ('C');
3 rows affected

CREATE TABLE tab(
id INT IDENTITY,
col VARCHAR(100)
)
INSERT INTO tab(col)
OUTPUT inserted.id, inserted.col
SELECT col
FROM #temp;


id
col


1
A

2
B

3
C


CREATE TABLE #temp_identity(id INT)
INSERT INTO tab(col)
OUTPUT inserted.id
INTO #temp_identity
SELECT col
FROM #temp;
3 rows affected

SELECT *
FROM #temp_identity


id


4

5

6