以 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â,å³é»æ¢å é¤ï¼æ示âé误â