UPDATE TestData
SET data = data + 20
OUTPUT INSERTED.id,
DELETED.data AS [old data], 
INSERTED.data AS [new data]
WHERE data>100


DELETE TestData
OUTPUT DELETED.id, DELETED.data
WHERE data < 1000


INSERT TestData 
OUTPUT INSERTED.id, INSERTED.data
VALUES (100)

a
b
c
d
