100分!100分!一个触发器更新的问题!

Question

把 deleted 改为 ：(select 不需求和列,sum(需求和列) from deleted group by 不需求和列) deleted1把 inserted 改为 ：(select 不需求和列,sum(需求和列) from inserted group by 不需求和列) inserted1

Answer 1

把 deleted 改为 ：(select 不需求和列,sum(需求和列) 需求和列名 from deleted group by 不需求和列) deleted1把 inserted 改为 ：(select 不需求和列,sum(需求和列) 需求和列名  from inserted group by 不需求和列) inserted1

Answer 2

感谢!大力! 大力,我对你的^^^^^^^^答如下,可以参考:
CREATE TRIGGER Change_Update ON [dbo].[stk_Stock_Sub] 
FOR Deleted
ASUpdate Bas_ItemMaster  Set Bas_ItemMaster.Num=Bas_ItemMaster.Num-Deleted1.SumNumber,
                           Bas_ItemMaster.SumMoney=bas_ItemMaster.SumMoney-Deleted1.SumMoney,
                                        Bas_ItemMaster.Size1=Bas_ItemMaster.Size1-Deleted1.SSize1,
                                        Bas_ItemMaster.Size2=Bas_ItemMaster.Size2-Deleted1.SSize2,
                                        Bas_ItemMaster.Size3=Bas_ItemMaster.Size3-Deleted1.SSize3,
                                        Bas_ItemMaster.Size4=Bas_ItemMaster.Size4-Deleted1.SSize4,
                                        Bas_ItemMaster.Size5=Bas_ItemMaster.Size5-Deleted1.SSize5,
                                        Bas_ItemMaster.Size6=Bas_ItemMaster.Size6-Deleted1.SSize6,
                                        Bas_ItemMaster.Size7=Bas_ItemMaster.Size7-Deleted1.SSize7,
                                        Bas_ItemMaster.Size8=Bas_ItemMaster.Size8-Deleted1.SSize8,
                                        Bas_ItemMaster.Size9=Bas_ItemMaster.Size9-Deleted1.SSize9,
                                        Bas_ItemMaster.Size10=Bas_ItemMaster.Size10-Deleted1.SSize10,
                                        Bas_ItemMaster.Size11=Bas_ItemMaster.Size11-Deleted1.SSize11,
                                        Bas_ItemMaster.Size12=Bas_ItemMaster.Size12-Deleted1.SSize12,
                                        Bas_ItemMaster.Size13=Bas_ItemMaster.Size13-Deleted1.SSize13,
                                        Bas_ItemMaster.Size14=Bas_ItemMaster.Size14-Deleted1.SSize14,
                                        Bas_ItemMaster.Size15=Bas_ItemMaster.Size15-Deleted1.SSize15,
                                        Bas_ItemMaster.Size16=Bas_ItemMaster.Size16-Deleted1.SSize16,
                                        Bas_ItemMaster.Size17=Bas_ItemMaster.Size17-Deleted1.SSize17,
                                        Bas_ItemMaster.Size18=Bas_ItemMaster.Size18-Deleted1.SSize18,
                                        Bas_ItemMaster.Size19=Bas_ItemMaster.Size19-Deleted1.SSize19,
                                        Bas_ItemMaster.Size20=Bas_ItemMaster.Size20-Deleted1.SSize20,
                                        Bas_ItemMaster.Size21=Bas_ItemMaster.Size21-Deleted1.SSize21,
                                        Bas_ItemMaster.Size22=Bas_ItemMaster.Size22-Deleted1.SSize22
                                    from Bas_ItemMaster inner join 
                                         (Select ItemCode,
         Sum(Value) as SumNumber,
                                                 Sum(value*Price/(1+Duty)) as SumMoney,
                                                 Sum(Size1) as SSize1,
                                                 Sum(Size2) as SSize2,
                                                 Sum(Size3) as SSize3,
                                                 Sum(Size4) as SSize4,
                                                 Sum(Size5) as SSize5,
                                                 Sum(Size6) as SSize6,
                                                 Sum(Size7) as SSize7,
                                                 Sum(Size8) as SSize8,
                                                 Sum(Size9) as SSize9,
                                                 Sum(Size10) as SSize10,
                                                 Sum(Size11) as SSize11,
                                                 Sum(Size12) as SSize12,
                                                 Sum(Size13) as SSize13,
                                                 Sum(Size14) as SSize14,
                                                 Sum(Size15) as SSize15,
                                                 Sum(Size16) as SSize16,
                                                 Sum(Size17) as SSize17,
                                                 Sum(Size18) as SSize18,
                                                 Sum(Size19) as SSize19,
                                                 Sum(Size20) as SSize20,
                                                 Sum(Size21) as SSize21,
                                                 Sum(Size22) as SSize22 from Deleted Group By ItemCode) Deleted1
                                                 on Bas_ItemMaster.Code=Deleted1.ItemCode