摘要
文章以T-SQL技术为基础,介绍了基于CTE语句进行数据库查询的产生机理和实现方法,并针对CTE语句的特点,采用存储过程及自定义函数方式来实现基于CTE语句查询数据库的过程.以人员管理树型结构数据为基础,在SQL Server 2005中建立各种CTE临时结果集,进行递归查询操作,从而体现T-SQL语言中新增CTE递归查询的强大功能.
This Article is based on T-SQL technique. It introduces mechanism and method of using CTE to search a Database. According to the characteristics of CTE, this paper adopts storage processing and definition function to realize the process of searching Database through CTE. With tree data structure of personnel management, it also builds up various temporaryresuh gathers of CTE in SOL 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.
出处
《沈阳师范大学学报（自然科学版）》
CAS
2007年第2期217-219,共3页
Journal of Shenyang Normal University:Natural Science Edition
