sy6_1_3.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 17 行

create trigger person_insert
    on pay
    for insert
    as
        declare @num_rows int
        select  @num_rows=@@rowcount
        if @num_rows=0
             return
        if (select count(*)
            from person p,inserted i
            where p.no=i.no)!=@num_rows
        begin
            raiserror 33333 '试图插入非法的员工号到pay表中'
            rollback transaction
            return
        end
   return