SQL得到某个节点所有下级节点的集合
WITH DeptTree AS
(
SELECT PK_ID from IBP_T_Department where PK_ID = 158--需要查找的节点
UNION ALL
SELECT IBP_T_Department.PK_ID from DeptTree
JOIN IBP_T_Department on DeptTree.PK_ID = IBP_T_Department.iParentID
)
select STUFF((SELECT ','+CAST(PK_ID AS VARCHAR(100)) from DeptTree WHERE PK_ID<>155 FOR XML PATH('')),1,1,'')
上面语句无论有多个级都适用