触发器

Sqlserver示例

编辑

insert

1 2 3 4 5 6 7 8 9 10 11 12 13

create trigger tri_insert on student for insert as declare @student_idchar(10) select @student_id=s.student_id from students inner join insertedion s.student_id=i.student_id if @student_id='0000000001' begin raiserror('不能插入1的学号!',16,8) rollbacktran end go

update

1 2 3 4 5 6 7 8 9 10

create trigger tri_update on student for update as if update(student_id) begin raiserror('学号不能修改!',16,8) rollbacktran end go

delete

1 2 3 4 5 6 7 8 9 10 11

create trigger tri_delete on student for delete as declare @student_idvarchar(10) select @student_id=student_id from deleted if @student_id='admin' begin raiserror('错误',16,8) rollbacktran end