【求助】正在学习触发器

if (object_id('tgr_inteadOf_insertSC', 'TR') is not null)
    drop tgr_inteadOf_insertSC
go
create tgr_inteadOf_insertSC
on SC
    instead of insert
as
    declare @kecheng varchar(20);
    declare @recCount int;
    select @kecheng=kecheng from inserted
    select @recCount=count(*) from SC where kecheng=@kecheng
    if @recCount>=4
        print '已超过最大选课人数'
    else
    begin
        insert into SC select kecheng,xuehao,chengji from inserted
        print '选课成功'
    end
go

[此贴子已经被作者于2015-12-24 12:38编辑过]

不用阻止，当有4条记录时都不执行insert