关系数据库中对于层次结构数据的处理分析

Analysis of how to Manage Hierarchical Structure Data in Relational Database

在数据库应用系统开发中，经常要对层次结构数据进行管理，实现的方法有多种，比较分析了每种方法的优缺点。利用Mi—crosoft SQL Server 2005中的新功能公用表表达式（CTE，Common Table Expression）进行递归查询，结合组织机构管理的具体实例，给出了使用CTE进行递归查询的组织机构管理的通用实现方法。

In develop of database application system, often manages the hierarchical structure data, there are many methods, analyses the advantages and disadvantages of each method by comparing. Implements recursive query with the common table expression the new function of Microsoft SQL Server 2005, on the example of organizations management, provides the general way of how to manage organizations through recursive query using CTE.