SqlServer 樹結構資料 子節點父節點的查詢

標籤：io   ar   資料   sp   on   c   sql   table   har   

declare @t table (C_ID int,PcName varchar(6),ParentID int)
insert into @t
select 1,‘安徽‘,0 union all
select 2,‘安慶‘,1 union all
select 3,‘安慶市‘,2 union all
select 4,‘懷寧縣‘,2 union all
select 5,‘潛山縣‘,2 union all
select 6,‘宿松縣‘,2 union all
select 7,‘太湖縣‘,2 union all
select 8,‘桐城市‘,2 union all
select 9,‘望江縣‘,2 union all
select 10,‘嶽西縣‘,2 union all
select 11,‘樅陽縣‘,2

;with maco as
(
select * from @t where c_id=11
union all
select t.* from @t t,maco m where t.C_ID=m.ParentID
)
select * from maco order by c_id

/*
C_ID PcName ParentID
----------- ------ -----------
1 安徽 0
2 安慶 1
11 樅陽縣 2
*/

 

SqlServer 樹結構資料 子節點父節點的查詢