create trigger on a
for insert
as
begin
declare @tt int
select @tt=sum(a.price) from a ,inserted c where a.user=c.user
update b set total=@tt from inserted c,where c.user=b.user
end
for insert
as
begin
declare @tt int
select @tt=sum(a.price) from a ,inserted c where a.user=c.user
update b set total=@tt from inserted c,where c.user=b.user
end
for insert
as
begin
declare @tt int
select @tt=sum(a.price) from a ,inserted c where a.user=c.user
update b set total=@tt from inserted c where c.user=b.user
end