CREATE TRIGGER [MatInit_upStock] ON dbo.iMatInitD FOR UPDATE AS insert into B (f1 , f2 ,f3 ) select MatCode,ColorCode ,basedigit from inserted
当批量更新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)
FOR UPDATE
AS
insert into B (f1 , f2 ,f3 )
select MatCode,ColorCode ,basedigit
from inserted
(select RTRIM(inserted.MatCode)+'_'+rtrim(inserted.ColorCode)+rtrim(inserted.brandName)+'_'+rtrim(inserted.PackageName)+'_'+rtrim(inserted.size2) from inserted)