ALTER procedure [dbo].[Pro_UpdTb_ContractFee3]
@FeeName varchar(50),
@ContractNo varchar(50),
@DelSum floatas
begin
update Tb_ContractFee set
ReceiveAmount=isnull(ReceiveAmount,0)-@DelSum //这句没作用,调用运行后数据库表的ReceiveAmount减去不了值
--ReceiveAmount=ReceiveAmount-@DelSum //试运行这句也没作用
where FeeName=@FeeName and ContractNo=@ContractNo
@FeeName varchar(50),
@ContractNo varchar(50),
@DelSum floatas
begin
update Tb_ContractFee set
ReceiveAmount=isnull(ReceiveAmount,0)-@DelSum //这句没作用,调用运行后数据库表的ReceiveAmount减去不了值
--ReceiveAmount=ReceiveAmount-@DelSum //试运行这句也没作用
where FeeName=@FeeName and ContractNo=@ContractNo
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货