With tree data structure of personnel management,it also builds up various temporary result gathers of CTE in SQL Server 2005 to complete the recurrence search operation,so that it shows strong function of recurrence query of CTE in the language of T-SQL.

• 以人员管理树型结构数据为基础；在SQL Server 2005中建立各种CTE临时结果集；进行递归查询操作；从而体现T-SQL语言中新增CTE递归查询的强大功能.