On Recurrence Query of the Language T-SQL
Liu Jin · Journal of Shenyang Normal University · 2007
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.