怎么优化触发器过程

[辉百元]

alter TRIGGER test22
ON [dbo].[ICStockBill]
after insert
AS
SET NOCOUNT ON
DECLARE @FTranType SMALLINT
SELECT @FTranType=FTranType
FROM INSERTED

if not UPDATE(fstatus)
return

if(@FTranType=24)
begin
update a set a.FHeadSelfY0237=b.FBillNo from PPBOM a ,ICStockBillEntry c,
ICStockBill b where c.FInterID=b.FInterID and a.FHeadSelfY0236=c.FICMOBillNo

end
生产领料单新增时 将 b.FBillNo反写到 a.FHeadSelfY0237 如何做到只刷新当前记录 而不刷以前的数据

[二月十六]

ALTER TRIGGER test22
ON [dbo].[ICStockBill]
AFTER INSERT
AS
SET NOCOUNT ON;
DECLARE @FTranType SMALLINT;
SELECT @FTranType = FTranType
FROM INSERTED;

IF NOT UPDATE(fstatus)
    RETURN;

IF (@FTranType = 24)
BEGIN
    UPDATE a
    SET A.FHeadSelfY0237 = B.FBillNo
    FROM PPBOM a,
         ICStockBillEntry c,
         INSERTED b
    WHERE c.FInterID = b.FInterID
          AND a.FHeadSelfY0236 = c.FICMOBillNo;

END;

[Dear SQL(燊)]

有可能一次insert多条，条件写在where里面

ALTER TRIGGER test22
ON [dbo].[ICStockBill]
AFTER INSERT
AS
SET NOCOUNT ON;

IF NOT UPDATE(fstatus)
    RETURN;
 

UPDATE a
SET A.FHeadSelfY0237 = B.FBillNo
FROM PPBOM a,
        ICStockBillEntry c,
        INSERTED b
WHERE c.FInterID = b.FInterID
        AND a.FHeadSelfY0236 = c.FICMOBillNo
		AND FTranType=24;

[Hello World,]

把ICStockBill换成inserted，这个表就是代表当前写入的数据