DECLARE @MyTableVar table(
ScrapReasonID smallint,
Name varchar(50),
ModifiedDate datetime);
INSERT Production.ScrapReason
OUTPUT INSERTED.ScrapReasonID, INSERTED.Name, INSERTED.ModifiedDate
INTO @MyTableVar
VALUES (N 'Operator error ', GETDATE());
SELECT ScrapReasonID, Name, ModifiedDate FROM @MyTableVar;