提问,如何递归触发delete触发器
删除树某节点下所有叶节点
delete触发器如下,但是结果只触发了一次触发器自己里边的delete没有触发
delete触发器,为什么,有什么办法解决
CREATE TRIGGER [删除地域] ON dbo.AREA
FOR Delete
AS
declare @jj varchar(20)
declare @ii varchar(20)
if @@rowcount =1
begin
set @jj=(select Area_UC from Deleted)
set @ii=(Select Area_CC From Deleted)
print @jj
Update Area Set Area_DNum=Area_DNum-1 where Area_CC=@jj
delete from Area Where Area_UC=@ii
end