当我们看见这个问题的时,首先想到的是拦截器,sql数据操作拦截器,首先第一个想到的是sql instead of触发器,instead of触发器可以拦截insert update delete操作。 下文将举例说明,instead of触发器对表删除的拦截 create table A(keyId int,info varchar(20)) go insert into A(keyId,info)values(1,'a'),(2,'b'),(3,'c'),(4,'d') go create trigger tr_A on A instead of delete as begin select '禁止对表进行删除操作' return; end go delete from A go select * from A go truncate table A drop table A go