上图为sys_org表的数据,该表为一颗组织树的数据,现用sql语句递归的语法吧业务部的下属子节点找出来
declare @tagName varchar(20)
set @tagName='业务部'
;with
ceshi as
(
select * from sys_org where name=@tagName
union all
select t.* from ceshi j join sys_org t on j.id=t.parentid
)
SELECT * from ceshi
结果如下图所示