create trigger tr_insert on tab1
for insert
as
declare @a varchar(10)
select @a = a from inserted
if not exists(select * from tab2 where b=@a)
insert tab2(b) values(@a)
go
for insert
as
declare @a varchar(10)
select @a = a from inserted
if not exists(select * from tab2 where b=@a)
insert tab2(b) values(@a)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货