//加上delete create trigger tri_Delete on Employees for insert,update,delete as begin declare @inset char(6),@delet char(6) select @inset=编号 from inserted select @delet=编号 from deleted if (update(编号)) begin update Sell set 售货员工编号=@inset where 售货员工编号=@delet end else begin delete from Sell where 售货员工编号=@delet end end update Employees set 编号='1304' where 姓名='王峰' delete from Employees where 姓名='王峰'
create trigger tri_Delete
on Employees for insert,update,delete
as
begin
declare @inset char(6),@delet char(6)
select @inset=编号 from inserted
select @delet=编号 from deleted
if (update(编号))
begin
update Sell
set 售货员工编号=@inset
where 售货员工编号=@delet
end
else
begin
delete from Sell
where 售货员工编号=@delet
end
end update Employees
set 编号='1304'
where 姓名='王峰' delete from
Employees
where 姓名='王峰'