--条件判断失误,改成这样--处理的触发器
create trigger tr_process on a
for insert,update
as
insert b(verno,code,item,qty)
select a.verno,b.code,b.item,b.qty
from(
select distinct verno from b
)a,(select code,item,qty from inserted where base_flag=1)b
where not exists(
select * from b bb
where verno=a.verno and code=b.code and item=b.item)
go
create trigger tr_process on a
for insert,update
as
insert b(verno,code,item,qty)
select a.verno,b.code,b.item,b.qty
from(
select distinct verno from b
)a,(select code,item,qty from inserted where base_flag=1)b
where not exists(
select * from b bb
where verno=a.verno and code=b.code and item=b.item)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货