触发器

create trigger sc_fk on SC

for insert

as

begin

if(

select count(*) from 表 where 条件 and 条件)<=0

rollback

end