update 班级 set rs=(select count(*) from 学生基本信息表 where 班级=t.班级) from 班级 t
create trigger gg on 学生基本信息表 for insert as update t set rs=i.sumrs from 班级 t ,(select 班级,count(1) from inserted group by 班级) i where t.班级=i.班级 go create trigger gg on 学生基本信息表 for delete as update t set rs=i.sumrs from 班级 t ,(select 班级,count(1) from deleted group by 班级) d where t.班级=d.班级 go
for insert,delete
as
update 班级
set rs=(select count(*) from 学生基本信息表 where 班级=t.班级)
from 班级 t
for insert
as update t
set rs=i.sumrs
from 班级 t ,(select 班级,count(1) from inserted group by 班级) i
where t.班级=i.班级
go
create trigger gg on 学生基本信息表
for delete
as update t
set rs=i.sumrs
from 班级 t ,(select 班级,count(1) from deleted group by 班级) d
where t.班级=d.班级
go