SQL Server 2019

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

CREATE TABLE dbo.MyTable
(
  id int identity,
  description varchar(32),
  name varchar(32)
);
INSERT INTO dbo.MyTable ([description], [name])
OUTPUT inserted.id, inserted.description, inserted.name
VALUES ('animal', 'cat');


id
description
name


1
animal
cat


INSERT INTO dbo.MyTable ([description], [name])
OUTPUT inserted.id, inserted.description, inserted.name
VALUES ('alien', 'blorb');


id
description
name


2
alien
blorb