create trigger tri_insert
on student
for insert
as
declare @student_idchar(10)
select @student_id=s.student_id
from students inner join insert
edion s.student_id=i.student_id
if@student_id=‘0000000001’
beginraiserror(‘不能插入1的号!’,16,8)
rollbacktran
end
go
update的示例
create trigger tri_update
on student
for update
as
ifupdate(student_id)begin
raiserror(‘学号不能修改!’,16,8)
rollbacktran
end
go
delete的示例
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
go