摘要:
查询所有的:select Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName from BusinessUnit--查询某一节点的所有子节点with cte(Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName)as(select Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName from BusinessUnit where Name='会员管理与 阅读全文