闲来无事,测了一下触发器更新原理,发现触发器中的所谓更新实为先删后加,并将测试代码记录一下
create table tb
(
id int
)
create table tbb
(
des varchar(50),
id int
)
go
create trigger tritest
on tb
for update
as
insert into tbb select '删除的id',id from deleted
insert into tbb select '插入的id',id from inserted
go
insert into tb(id) values(1)
select * from tb
select * from tbb
/*
id
-----------
1
(1 行受影响)
des id
-------------------------------------------------- -----------
(0 行受影响)
*/
update tb set id=5 where id=1
select * from tb
select * from tbb
/*
id
-----------
5
(1 行受影响)
des id
-------------------------------------------------- -----------
删除的id 1
插入的id 5
(2 行受影响)
*/