以 delete 触å为ä¾ï¼
create trigger tri_delete
on a --å°è¦è¿è¡æ´æ¹ç表å
for delete --ç»è¡¨å é¤ä¸æ¡æ°æ®çæ¶å触å
as
declare @aa varchar(10)
select @aa=a from deleted
if @aa='a' --å¤ççæ¡ä»¶
begin
raiserror('é误',16,8)
rollback tran
end
触åå¨ææï¼å é¤è¡¨aæ°æ®ï¼å¦æaå为 âaâ,å³é»æ¢å é¤ï¼æ示âé误â
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a9d3fd1f4134970aa4963ec693cad1c8a6865d75?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)