• I wondered the same thing and came up with the following:

    DECLARE @Output table( ID int, Code VARCHAR(25), Name VARCHAR(50), Salary Numeric(10 , 2))

    INSERT INTO TempTable ( Code , Name, Salary)

    OUTPUT Inserted.ID

    , Inserted.Code

    , Inserted.Name

    , Inserted.Salary

    INTO @Output

    VALUES( 'A005' , 'Jennifer', 500 )

    It would have been helpful if OUTPUT INTO were discussed in the article. Otherwise, a great tip!