sqlserver2005 递归查询

概述递归查询，记录一下， CREATE TABLE [abc]( [id] [int] NULL, [pid] [int] NULL, [name] [nchar](10) ) GO INSERT INTO [abc] VALUES(1,0,'a') INSERT INTO [abc] VALUES(2,0,'b') INSERT INTO [abc] VALUES(3,1,'c') INSERT I

递归查询，记录一下，

CREATE table [abc](
[ID] [int] NulL,
[pID] [int] NulL,
[name] [nchar](10)
)
GO
INSERT INTO [abc] VALUES(1,'a')
INSERT INTO [abc] VALUES(2,'b')
INSERT INTO [abc] VALUES(3,1,'c')
INSERT INTO [abc] VALUES(4,'d')
INSERT INTO [abc] VALUES(5,2,'e')
INSERT INTO [abc] VALUES(6,3,'f')
INSERT INTO [abc] VALUES(7,'g')
INSERT INTO [abc] VALUES(8,4,'h')
GO

--begin
with Dep as
(
select ID,pID,[name] from abc where ID=1
union all
select d.ID,d.pID,d.[name] from Dep inner join abc d on Dep.ID=d.pID
)
select * from Dep

-- end

上边是个整体的sql,开始以为后边的select是单独的呢

找的资料，自己记录一下

总结

以上是内存溢出为你收集整理的sqlserver2005 递归查询全部内容，希望文章能够帮你解决sqlserver2005 递归查询所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。