==========================================--insert 觸發(fā)器 create trigger tri_inserton studentfor insert as declare @student_id char(10)select @student_id=s.student_id from student s inner join inserted ion s.student_id=i.student_idif @student_id='0000000001' begin raiserror('不能插入1的學(xué)號!',16,8) rollback tran end go ]===============================================--update觸發(fā)器 create trigger tri_updateon studentfor update as if update(student_id)begin raiserror('學(xué)號不能修改!',16,8) rollback tran end go==================================--delete觸發(fā)器 create trigger tri_deleteon studentfor delete as declare @student_id varchar(10)select @student_id=student_id from deletedif @student_id='admin' begin raiserror('錯誤',16,8) rollback tran end================================================