首页 >数据库 >mysql教程 >Sqlserver触发器 示例

Sqlserver触发器 示例

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原创
2016-06-07 15:14:331256浏览

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 raiserro

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

go

update触发器示例

create trigger tri_update

on student

for update

as

if 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

if @student_id='admin'

begin

raiserror('错误',16,8)

rollback tran

end

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn