如果要把tradelist整张表全部修改AllTotal 我想用游标可以实现Declare @alltotal float--金额Declare @TradeNO2 varchar(max)--单号Declare cur cursor for select TradeNO2from tradelistopen Cur fetch next from cur into @TradeNO2while(@@fetch_status=0) begin
Select @alltotal=sum(TotalMoney) from apilist where TradeNO in(SelectTrad...