Get the output of INSERT, DELETE, and UPDATE statements

DELETE

FROM StamTable2

OUTPUT deleted.*

WHERE StamTableId > 11

INSERT INTO StamTable2 (StamTableStr, StamTableStr2)

OUTPUT inserted.*

SELECT StamTableStr, StamTableStr FROM StamTable WHERE StamTableId > 11

UPDATE StamTable2

SET StamTableStr2 = StamTableStr2 + '_UPDATED'

OUTPUT deleted.*, inserted.*

WHERE StamTableId > 11

Note: This OUTPUT doesn't work when there are 'instead of' triggers.