简单触发器

create trigger triggerStudent

on Student after insert

as

declare @ID int;

select @ID=classID from inserted

update class set num=num+1 where ID=@ID