摘要：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 阅读全文

摘要：1 use test--用于哪个数据库 2 go 3 create trigger trig_test1 --创建触发器名称 4 on tb_test--用于哪张表 5 after insert --在插入数据之后做的动作 6 as 7 update tb_test set test1='ok' 8 where ID in (select ID from inserted) 9 go 阅读全文