--> 测试数据：[MIS_InsertInfo]
if object_id('[MIS_InsertInfo]') is not null drop table [MIS_InsertInfo]
create table [MIS_InsertInfo]([InsertInfo_Name] varchar(1),[Number] int,[InsertInfo_Amount] int)
insert [MIS_InsertInfo]
select 'a',1,10 union all
select 'b',2,50
--> 测试数据：[MIS_Stocks]
if object_id('[MIS_Stocks]') is not null drop table [MIS_Stocks]
create table [MIS_Stocks]([Stocks_Name] varchar(1),[Stocks_Total] int)
insert [MIS_Stocks]
select 'a',20 union all
select 'b',30

update [MIS_Stocks] set [Stocks_Total]=[Stocks_Total]+a.[InsertInfo_Amount]
from [MIS_InsertInfo] a where a.InsertInfo_Name=[MIS_Stocks].Stocks_Name

select * from [MIS_Stocks]

/*
Stocks_Name    Stocks_Total
a    30
b    80
*/