学步园

2005-6-21

modify数据时临时暂停触发器的作用

create table mytable (mobile char(11))
create table myresult (mobile char(11))

create trigger mytrigger on  mytable 
for insert
as
insert into myresult (mobile)
select mobile from inserted

insert into mytable (mobile) values('13831111947')

select * from mytable
select * from myresult
--俩个表中都有
alter table mytable disable trigger all

insert into mytable (mobile) values('13831111948')

select * from mytable
select * from myresult
--只有第一个表中有,被触发的表中没有
alter table mytable enable trigger all

insert into mytable (mobile) values('13831111949')

select * from mytable
select * from myresult
--两个表中都有