触发器中如何取到表中某一列的累加值
如何实现在触发器中把某一列之和赋给某一变量。谢谢！
希望把tableA中符合条件的A列之和赋给变量@sum。如何实现？
declare @finterid int
declare @sum int
……
select sum(A) as @sum from tableA
where finterid=@finterid
……
select @sum = sum(A) from tableA
where finterid=@finterid
create trigger tr_TableA on tableA
for insert,update
as
update t2
set SumA=t1.SumA
from (select finterid,sum(A) as SumA
from tableA where finterid in(select finterid from inserted)
group by finterid) as t1
inner join tableA as t2 on t1.finterid=t2.finterid
