删除触发器不起作用 [英] Delete Trigger Not Working

问题描述

我有两个表1.Employee_Test 2. Employee_Test_Audit我创建了如下所示的触发器但是当我从表一中删除记录（Employee_Test）时，第二个表（Employee_Test_Audit）数据没有被删除......：p

i have two table 1.Employee_Test 2. Employee_Test_Audit i create trigger like below but when i delete record from table one (Employee_Test) then second table(Employee_Test_Audit) data was not deleted ...... :p

ALTER TRIGGER Trigger1_Delete
ON dbo.Employee_Test
FOR   DELETE
AS
    declare @empid numeric(18, 0);	
	
    select @empid=i.Emp_ID from inserted i;		
	
   DELETE FROM Employee_Test_Audit where Emp_ID=@empid

推荐答案

从Employee_Test_Audit中删除任何内容的原因是因为@empid为null。您正在DELETE触发器中查询虚拟INSERTED表...更改

The reason that nothing is being deleted from the Employee_Test_Audit is because @empid is null. You are querying the virtual INSERTED table whilst in a DELETE trigger... change

select @empid=i.Emp_ID from inserted i;

到

select @empid=i.EmpID from deleted i;

这篇关于删除触发器不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！