创建一条函数用来读取当前节点的所在子节点的NodeId(包含本身)f_SelectChild
然后创建存储过程来实现。
语句如下:
delete from NodeTable
where NodeId in (select NodeIdfrom f_SelectChild(@NodeId))
然后创建存储过程来实现。
语句如下:
delete from NodeTable
where NodeId in (select NodeIdfrom f_SelectChild(@NodeId))
create trigger trig_del_tree
on 表 for delete
as
delete from 表
where ParentId in (select NodeID from deleted)
go