|
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
--两个表中都有 | 