达者均为吾师

摘要： --查询Id为1的所有子节点层数的数量;with cte as ( select id,parentId,0 as Leave from _TestLeave where id = 1 --要查询的节点 union all select a.id,a.parentId,b.Leave + 1 as Leave from _TestLeave a join cte b on a.parentId... 阅读全文