update moneyT(M_tin,M_out) select sum(M_in),sum(M_out) from moneyM where cz="aa001" declare @M_in int declare @M_out int declare @sql varchar(500) select @M_in=sum(M_in),@M_out=sum(M_out) from moneyM set @sql='update moneyT set M_tin='+@M_in+',M_out='+@M_out +'where cz='aa001' exec(@sql) select * from moneyT
上面的这句不要了: pdate moneyT(M_tin,M_out) select sum(M_in),sum(M_out) from moneyM where cz="aa001"
declare @M_in int
declare @M_out int
declare @sql varchar(500)
select @M_in=sum(M_in),@M_out=sum(M_out) from moneyM
set @sql='update moneyT set M_tin='+@M_in+',M_out='+@M_out +'where cz='aa001'
exec(@sql)
select * from moneyT
上面的这句不要了:
pdate moneyT(M_tin,M_out) select sum(M_in),sum(M_out) from moneyM where cz="aa001"