触发器的问题？

[yuzhifu1]

字段fstatus，0代表未审核，1代表审核，审核时不触发的语句怎么写？谢谢！！！

CREATE TRIGGER icstockbill_005
ON icstockbill 
FOR insert,update 
AS 
SET NOCOUNT ON 
IF EXISTS ( 
select 1 from 
(select a.fqty,a.ficmointerid,a.fitemid,a.fppbomentryid from icstockbillentry a
inner join inserted b on a.finterid=b.finterid and b.ftrantype=41 and b.fstatus=0
) t1
inner join ppbomentry t2 
on t2.ficmointerid=t1.ficmointerid and t2.fitemid=t1.fitemid and t2.fentryid=t1.fppbomentryid
where (t1.fqty+t2.fseltranslateauxqty)>(t2.fauxqtymust+t2.fauxqtysupply)
) 
BEGIN 
ROLLBACK TRAN 
RAISERROR('调拨数量不允许大于投料数量与补料数量之和!',18,18) 
END

[让你望见影子的墙]

审核时不触发的语句怎么写

这句话怎么讲？

[fa_ge]

If Exists(SELECT 1 FROM icstockbill WHERE finterid=xxx AND fstatus=1)
Return

[bancxc]

难道又是k3
这几个表都混熟了

[--小F--]

看不懂

[yujiang930]

if update(fstatus) And (select fstatusFrom Deleted) = 0 and (Select fstatus from Inserted) = 1


不是很清楚你想怎么做，具的你根据语句自己改一下就行了

[yuzhifu1]

就是fstatus=1不执行触发操作。

[yuzhifu1]

解决了，谢谢！

[yujiang930]

给分吧！