代码如下:if (object_id('PPBomentry_Insert', 'TR') is not null)
drop trigger PPBomentry_Insert
go
create TRIGGER [dbo].[PPBomentry_Insert] ON [dbo].[PPBOMentry]
FOR INSERT
AS
BEGIN DECLARE @InterID int SELECT @InterID=FInterID FROM inserted update p1 set p1.fqtymust=t2.fheadselfj0194,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%宽%' update p1 set p1.fqtymust=t2.FHeadSelfJ0195,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%高%' update p1 set p1.fqtymust=t2.FHeadSelfJ0196,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%副数%'
END
-------------------------------------
结果是最后一条无法更新,求达人帮忙看一下
drop trigger PPBomentry_Insert
go
create TRIGGER [dbo].[PPBomentry_Insert] ON [dbo].[PPBOMentry]
FOR INSERT
AS
BEGIN DECLARE @InterID int SELECT @InterID=FInterID FROM inserted update p1 set p1.fqtymust=t2.fheadselfj0194,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%宽%' update p1 set p1.fqtymust=t2.FHeadSelfJ0195,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%高%' update p1 set p1.fqtymust=t2.FHeadSelfJ0196,
p1.fauxqtymust=p1.fqtymust*p1.FAuxQtyScrap,
p1.fqtypick=p1.fqtymust*p1.FAuxQtyScrap,
p1.fauxqtypick=p1.fqtymust*p1.FAuxQtyScrap
from PPBOMentry p1,ICMO t2 ,inserted t1
where p1.FICMOInterID=t2.FinterID and t1.FInterID=p1.FInterID and p1.FNote like '%副数%'
END
-------------------------------------
结果是最后一条无法更新,求达人帮忙看一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货