Sqlserver触发器 示例
发布时间：2020-12-12 13:58:25 所属栏目：MsSql教程 来源：网络整理
导读：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 if @student_id='0000000001' begin raiserror
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 if @student_id='0000000001' begin raiserror('不能插入1的学号!',16,8) rollback tran end goupdate触发器示例create trigger tri_update for update if update(student_id) raiserror('学号不能修改!',sans-serif; font-size:14px; line-height:24px"> godelete触发器示例create trigger tri_delete for delete declare @student_id varchar(10) select @student_id=student_id from deleted if @student_id='admin' raiserror('错误',sans-serif; font-size:14px; line-height:24px"> end（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |