–触发器操作1–禁止插入数据1
create trigger tr_Student2
on Student
instead of insert
as
raiserror('以禁止插入数据!',10,1)
--禁止插入数据2
create trigger tr_Student4
on Student
after Insert
as
begin
raiserror('插入数据操作以回滚',10,1
–触发器操作1–禁止插入数据1
create trigger tr_Student2
on Student
instead of insert
as
raiserror('以禁止插入数据!',10,1)
--禁止插入数据2
create trigger tr_Student4
on Student
after Insert
as
begin
raiserror('插入数据操作以回滚',10,1