触发器的更新过程

闲来无事，测了一下触发器更新原理，发现触发器中的所谓更新实为先删后加，并将测试代码记录一下

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 行受影响)
*/