触发器中如何取到表中某一列的累加值
如何实现在触发器中把某一列之和赋给某一变量。谢谢！
希望把tableA中符合条件的A列之和赋给变量@sum。如何实现？

declare @finterid int 
declare @sum int 
……  
  select sum(A) as @sum from tableA
        where finterid=@finterid
……

以上在运行中提示错误，错误在指向以下代码：
select sum(A) as @sum from tableA

SQL 触发器 变量 TRIGGER
[解决办法]

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