请大家帮我看看这个触发器

[无锡阔微信息科技]

create trigger t_Icstocktrigger on icstockbillentry
for insert
as
begin
declare @SanFitemID int
set @SanFitemID=cast((select isnull(FEntrySelfB0169,0) from inserted) as int)
if @SanFitemID=20273
begin
update icstockbillentry u1,inserted i
set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'
where u1.finterID=i.finterID and u1.fentryID=i.fentryID
end
end


错误：
消息 102，级别 15，状态 1，过程 t_Icstocktrigger，第 9 行
'u1' 附近有语法错误。

[jwdream2008]

create trigger t_Icstocktrigger on icstockbillentry
for insert  
as
begin
 declare @SanFitemID int
 set @SanFitemID=cast((select isnull(FEntrySelfB0169,0) from inserted) as int)
 if @SanFitemID=20273
  begin
  update icstockbillentry 
  set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'  
  from icstockbillentry u1,inserted i
  where u1.finterID=i.finterID and u1.fentryID=i.fentryID
  end
end

[永生天地]

update u1
set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'
from icstockbillentry u1,inserted i
where u1.finterID=i.finterID and u1.fentryID=i.fentryID
end

[中国风]

update icstockbillentry u1,inserted i
set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'
where u1.finterID=i.finterID and u1.fentryID=i.fentryID

改為

update u1
set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用' 
from icstockbillentry u1,inserted i  
  where u1.finterID=i.finterID and u1.fentryID=i.fentryID

[wujinyuan]

update u1
set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'
from icstockbillentry u1,inserted i
where u1.finterID=i.finterID and u1.fentryID=i.fentryID

[无锡阔微信息科技]

不行啊又报错了
消息 4104，级别 16，状态 1，过程 t_Icstocktrigger，第 9 行
无法绑定由多个部分组成的标识符 "u1.FConsignPrice"。

[无锡阔微信息科技]

我马上结贴

[dawugui]

update icstockbillentry u1 
set FConsignPrice = 0 , FEntrySelfB0159 = 0 , FNote = '保用'  
from icstockbillentry u1 , inserted i  
where u1.finterID = i.finterID and u1.fentryID = i.fentryID

[chuifengde]

你的触发器这样写有隐患，如果一次插入多行就麻烦了

[chuifengde]

CREATE TRIGGER t_Icstocktrigger
ON icstockbillentry
FOR  INSERT
AS
BEGIN
	UPDATE u1 
	SET    u1.FConsignPrice = 0,
	       u1.FEntrySelfB0159 = 0,
	       u1.FNote = '保用'
	FROM icstockbillentry u1,INSERTED i
	WHERE  u1.finterID = i.finterID
	       AND u1.fentryID = i.fentryID
	       AND ISNULL(i.FEntrySelfB0169, 0)=20273
END 	         

[SQL_Hhy]

update u1
  set u1.FConsignPrice=0,u1.FEntrySelfB0159=0,u1.FNote='保用'  
from icstockbillentry u1,inserted i
  where u1.finterID=i.finterID and u1.fentryID=i.fentryID
  end