CTE递归

最新推荐文章于 2022-11-30 15:04:36 发布

aoagk60882

最新推荐文章于 2022-11-30 15:04:36 发布

阅读量86

点赞数

原文链接：http://www.cnblogs.com/zqsoft/archive/2012/05/12/2497333.html

版权

create table test
(
    id int,
    name varchar( 10),
    parentid int
)
select * from test

insert into Test values( 1, ' aa ', - 1)
insert into Test values( 2, ' aa ', - 1)
insert into Test values( 3, ' aa ', 1)
insert into Test values( 4, ' aa ', 1)
insert into Test values( 5, ' aa ', 3)
declare @id int = 1;
with TestCTE as
(
     select * from test where id = @id
      union all
      select test. * from TestCTE join test on test.parentid = TestCTE.id
)

转载于:https://www.cnblogs.com/zqsoft/archive/2012/05/12/2497333.html