摘要: 查询所有的:select Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName from BusinessUnit--查询某一节点的所有子节点with cte(Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName)as(select Name,BusinessUnitId,ParentBusinessUnitId,ParentBusinessUnitIdName from BusinessUnit where Name='会员管理与 阅读全文
posted @ 2012-11-09 13:51 jamin 阅读(270) 评论(0) 推荐(0) 编辑