Example of an INSERT, OUTPUT and SELECT transaction

insert-output-select.sql

DECLARE @a uniqueidentifier
DECLARE @b uniqueidentifier

SET @a = newid()
SET @b = newid()

DECLARE @t TABLE
(
  a uniqueidentifier,
  b uniqueidentifier
)

INSERT INTO @t
OUTPUT Inserted.a, Inserted.b
SELECT @a, @b
WHERE NOT EXISTS ( SELECT TOP 1 1 FROM @t WHERE a = @a )

INSERT INTO @t
OUTPUT Inserted.a, Inserted.b
SELECT @a, @b
WHERE NOT EXISTS ( SELECT TOP 1 1 FROM @t WHERE a = @a )