为什么没人回答?????????
不明白意思吗??????????
我已经解决了!!!!CREATE TRIGGER UpdateTable ON dbo.费用申请从表
FOR update
AS
declare @numberMoney money
declare @numberID int
select @numbermoney=金额 from deleted
select @numbermoney=金额-@numberMoney,@numberID=费用申请编号 from inserted
update 费用申请主表
set 总共=总共+@numberMoney
where 费用申请编号=@numberId
不明白意思吗??????????
我已经解决了!!!!CREATE TRIGGER UpdateTable ON dbo.费用申请从表
FOR update
AS
declare @numberMoney money
declare @numberID int
select @numbermoney=金额 from deleted
select @numbermoney=金额-@numberMoney,@numberID=费用申请编号 from inserted
update 费用申请主表
set 总共=总共+@numberMoney
where 费用申请编号=@numberId
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货