Question

sql server中，库下只是不允许删除某一张表，触发器怎么写啊

sql server中，库下只是针对某一张表，不允许做删除，触发器怎么写啊

Answer 1

SQL Server写法:
create trigger del_T on T
insert of delete
as
if exists(select 1 from deleted)
begin
raiserror 50001 N'不可删除'
return
end
go
或用

create trigger del_T on T
for delete
as
if exists(select 1 from deleted)
begin
raiserror 50001 N'不可删除'
rollback tran
end