sql2005示例数据库:Sql server触发器举例来源: 发布时间:星期二, 2009年2月3日 浏览:34次 评论:0
="t18">
--insert 触发器 create trigger tri_insert on student for insert as declare @student_id char(10) select @student_id=s.student_id from student s inner join inserted i on s.student_id=i.student_id @student_id='0000000001' begin raiserror('不能插入1学号!',16,8) rollback tran end go ] = --update触发器 create trigger tri_update on student for update as update(student_id) begin raiserror('学号不能修改!',16,8) rollback tran end go --delete触发器 create trigger tri_delete on student for delete as declare @student_id varchar(10) select @student_id=student_id from deleted @student_id='admin' begin raiserror('',16,8) rollback tran end 0
相关文章
读者评论发表评论 |
|