| 浅谈T-SQL语言之递归查询 |
| |
| 引用本文： | 刘进.浅谈T-SQL语言之递归查询[J].沈阳师范大学学报(自然科学版),2007,25(2):217-219. |
| |
| 作者姓名： | 刘进 |
| |
| 作者单位： | 江西服装职业技术学院,计算机系,江西,南昌,330201 |
| |
| 摘 要： | 文章以T-SQL技术为基础,介绍了基于CTE语句进行数据库查询的产生机理和实现方法,并针对CTE语句的特点,采用存储过程及自定义函数方式来实现基于CTE语句查询数据库的过程.以人员管理树型结构数据为基础,在SQL Server 2005中建立各种CTE临时结果集,进行递归查询操作,从而体现T-SQL语言中新增CTE递归查询的强大功能.
|
| 关 键 词： | 存储过程 |
| 文章编号： | 1673-5862(2007)02-0217-03 |
| 修稿时间： | 2007-01-08 |
On Recurrence Query of the Language T-SQL |
| |
| LIU Jin.On Recurrence Query of the Language T-SQL[J].Journal of Shenyang Normal University: Nat Sci Ed,2007,25(2):217-219. |
| |
| Authors: | LIU Jin |
| |
| Institution: | Department of Computer,Jiangxi College of Garment Industry, Nanchang 330201, China |
| |
| Abstract: | 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 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. |
| |
| Keywords: | T-SQL CTE |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
