Okay. You know how to display column values during a DELETE operation. You can do the same thing during an INSERT:

INSERT INTO Student
OUTPUT Inserted.Id, Inserted.LastName
VALUES (13, N'Alan', NULL, N'Stanley');

This returns a table with the names of the columns listed after OUTPUT, assigning them inserted values. You use the Inserted prefix to refer to newly inserted rows.

Notice that the OUTPUT clause is placed after the table name (Student) and before VALUES. After OUTPUT, we list the names of the columns getting the data, separated by commas (Id, LastName). Notice that these column names must be preceded by the Inserted prefix followed by a dot(Inserted.Id, Inserted.LastName).

As you've noticed, OUTPUT will display only chosen data or all inserted data (as in the DELETE statement we did previously). In the example above, we showed data from only two columns and from the inserted row.