SQLServer 递归查询
来源:互联网 发布:战地之王刷枪软件 编辑:程序博客网 时间:2024/06/08 10:57
--SQLServer 递归查询,主要用于建立树形结构IF OBJECT_ID('Categories') IS NOT NULL DROP TABLE CategoriesGOCREATE TABLE Categories ( CategoryID INT, CategoryName VARCHAR(20), ParentID INT )GOINSERT INTO Categories(CategoryID, CategoryName, ParentID) SELECT 1, 'Books', NULL UNION ALL SELECT 2, 'SQL Server', 1 UNION ALL SELECT 3, 'ASP.NET', 1 UNION ALL SELECT 4, 'General', 2 UNION ALL SELECT 5, 'SSIS', 2 UNION ALL SELECT 6, 'TSQL', 2 UNION ALL SELECT 7, 'SSRS', 2 UNION ALL SELECT 8, 'Beginners', 4 UNION ALL SELECT 9, 'Certification Guide', 4goWITH cte AS ( SELECT 0 AS lvl, CategoryID, CategoryName, ParentID, CAST(CategoryID AS VARCHAR(128)) AS Sort FROM Categories WHERE ParentID IS NULL UNION ALL SELECT p.lvl + 1, c.CategoryID, c.CategoryName, c.ParentID, CAST(p.Sort + '/' + CAST(c.CategoryID AS VARCHAR) AS VARCHAR(128)) FROM Categories c INNER JOIN cte p ON p.CategoryID = c.ParentID)SELECT CategoryID, SPACE(lvl * 4) + CategoryName AS CategoryName, Sort, ParentID FROM cteORDER BY Sort
0 0
- SqlServer递归查询
- sqlserver 递归查询
- SQLSERVER 2005 递归查询
- SQLSERVER 2005 递归查询
- sqlserver 递归查询
- sqlserver递归查询
- SqlServer递归查询
- SQLServer 递归查询
- SQLServer 递归查询
- SQLserver递归查询
- sqlserver递归查询
- SQLServer 递归查询
- sqlserver递归查询
- SqlServer递归查询
- SQLServer递归查询
- sqlserver 递归查询
- SQLSERVER 递归查询
- SQL递归查询 SqlServer/ORACLE递归查询
- 第四站 卧龙谷
- 从零到在虚拟机中搭建hadoop伪分布平台
- 判断是否为二叉树的后续遍历
- 第七题(3)
- smack中ProviderManager的学习
- SQLServer 递归查询
- pthread 基础编程
- Excel Sheet Column Number - LeetCode 171
- C#学习(1)
- cookielib和urllib2模块相结合模拟网站登录
- 我的第一篇博客。
- C语言输出整数整数前补全零
- SQLite的使用
- 《CTCI》1.3 变位词