捷信达应收合约金额修改SQL

use gshis
select * from v_gscorpprofile --应收合约单位列表
select * from gsProfileCA where PaidAmt ='115439'
select * from gsProfileCA where ProfileID ='159' and transid ='1363159'
--UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
update  gsProfileCA SET Amount = '115332.5' where ProfileID ='159' and transid ='1363159'

landv / landv.github.io

捷信达应收合约金额修改SQL #53