1 use test 2 go 3 create trigger trig_test1 4 on tb_test 5 after delete 6 as 7 select * from deleted 8 go