SQL Server 2000 中递归
来源:互联网 发布:联想软件下载 编辑:程序博客网 时间:2024/04/30 10:17
CREATE FUNCTION dbo.Fun_Get_Category_TreeInfo ( @CategoryID varchar(10) -- 若 @CategoryID = "" 则表示查询所有的节目,也就是父级代码为 -1 下的所有节目 ) RETURNS @TreeInfo Table ( [Category_id] [int] not null, [Parent_id] [int] null, [Category_name] [varchar](50) null, [Code] [varchar](10) null, [AllowDownAll] [char](1), [Operator_id] [smallint], [Define_time] [datetime], [Flag] [char](1), [categorypath] [varchar](100), [Level] [int] NOT NULL, [LevelFlag] [varchar] (200) NOT NULL ) AS BEGIN DECLARE @level As int SELECT @level = 0 if @CategoryID != '' Insert Into @TreeInfo SELECT Category_ID, Parent_ID, Category_Name, Code, allowDownAll,Operator_ID,Define_Time,Flag,Categorypath,@level, 'NULL-> ' + Cast(Category_ID As varchar(10)) FROM [Act_Category] WHERE [Category_ID] = @CategoryID else Insert Into @TreeInfo SELECT Category_ID, Parent_ID, Category_Name, Code, allowDownAll,Operator_ID,Define_Time,Flag,Categorypath,@level, 'NULL-> ' + Cast(Category_ID As varchar(10)) FROM [Act_Category] WHERE [Parent_ID] = -1 WHILE @@ROWCOUNT > 0 BEGIN SET @level = @level + 1 INSERT INTO @TreeInfo SELECT E.[Category_ID], E.[Parent_ID], E.[Category_Name], E.[Code], E.[allowDownAll],E.[Operator_ID],E.[Define_Time],E.[Flag],E.[Categorypath], @level, T.[LevelFlag] + '->' + Cast(E.[Category_ID] As varchar(10)) FROM [Act_Category] AS E JOIN @TreeInfo AS T ON E.[Parent_ID] = T.[Category_ID] AND T.[Level] = @level - 1 END Return END
- SQL Server 2000 中递归
- sql server 2000 递归操作方法
- sql server 2000/2005递归
- sql server中递归的实现
- Sql server中递归的用法
- [sql server]sql 2000 函数递归算法
- sql server 2000 递归显示数据
- SQL Server 递归查询
- sql server 递归查询
- SQL SERVER 递归 CTE
- sql server 递归查询
- sql server递归查询
- sql server 递归查询
- SQL Server递归查询
- SQL SERVER实现递归
- SQL server递归查询
- SQL Server中递归触发器中使用游标如何设置
- SQL Server 2005中递归查询的写法
- ASP.NET下用MD5加密密码
- C++编程常见的内存错误及其对策
- MFC controls
- WinSock网络编程实用宝典
- 页面浏览限制
- SQL Server 2000 中递归
- 在防火墙后安装Rails
- 77种javascript特效全功略(包含日期等什么的)
- OpenOffice.org常见问题解答
- 我的博客
- C#中一些字符串操作的常用用法
- 在.NET中产生随机密码字符串
- 线程
- 提供一个基于.NET的加密/解密算法