为什么这个触发器触发了2次
CREATE TRIGGER Fnumber_t_ICitemCore_INSERT ON dbo.t_ICitemCore
WITH ENCRYPTION
FOR INSERT
AS
DECLARE
@ItemID int,
@fshortnumber varchar(100),
@fnumber varchar(100),
@maxfshortnumber varchar(100),
@maxfnumber varchar(100),
@fparentid int
SELECT @ItemID=Fitemid,@fparentid=fparentid
FROM INSERTED
if(@@rowcount=1)
begin
select @maxfnumber=max(Fnumber) from t_ICitemCore where fparentid=@fparentid
select @fnumber=right('000'+rtrim(replace(@maxfnumber,'.','')+1),5)
select @fnumber=stuff(stuff(@fnumber, 2, 0, '.'), 4, 0, '.')
select @maxfshortnumber=right(@fnumber,3)
update t_ICitemCore set fnumber=@fnumber,fshortnumber=@fshortnumber where fitemid=@ItemID
update t_item set fnumber=@fnumber,fshortnumber=@fshortnumber,ffullnumber=@fnumber where fitemid=@ItemID
insert test values(1,2)
end
编码老是+2递增,我建了表test确实进去2条记录,这是为什么