trigger check_trig.sql

在学习SQL Server过程中整理的T-SQL语句

use test

if exists(select name from sysobjects where name='check_trig' and type='TR')
   drop trigger check_trig
go

create trigger check_trig
     on XS_KC
     for insert
as
select *
    from inserted a
         where a.sno not in (select b.sno from XS b) or
               a.course not in(select c.course from KC c)
if @@ROWCOUNT>0
  begin
        raiserror('违背数据的一致性。',16,1)
        rollback transaction
  end