UPDATE触发器问题

[fs_hzj]

在A表上写一UPDATE触发器，当更新多行时，不能正确将结果INSERT到B表

触发器如下：
CREATE TRIGGER [MatInit_upStock] ON dbo.iMatInitD
FOR UPDATE
AS

select @cMatCode=MatCode , @cMatColor=ColorCode ,@nDigit=basedigit
from inserted

insert into B (f1 , f2 ,f3 )
values (@cMatCode ,@cMatColor ,@ndigit)


结果，当多行更新时，只将最后一行INSERT到B中，如何将批量更新的多行INSERT到B中？

[zbxubing]

inserted本身就是表
可以
insert into B (f1 , f2 ,f3 )
select MatCode , ColorCode ,basedigit
from inserted

[selectplayer]

CREATE TRIGGER [MatInit_upStock] ON dbo.iMatInitD
FOR UPDATE
AS
insert into B (f1 , f2 ,f3 )
select MatCode,ColorCode ,basedigit
from inserted

[fs_hzj]

当批量更新A时,我要根据INSERTED更新B表的行时,这样写不正确,该怎样处理呢?

update imatstorage2 set totalstock=totalstock+(select basedigit from inserted) where matbatchcode=
(select RTRIM(inserted.MatCode)+'_'+rtrim(inserted.ColorCode)+rtrim(inserted.brandName)+'_'+rtrim(inserted.PackageName)+'_'+rtrim(inserted.size2) from inserted)