output clause in sql

The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE  statements.