sqlÓï¾ä»ñÈ¡Ò¶×Ó½Úµã

±í½á¹¹ Ϊ
id parentid name
1    0
2    0
3    1
4    3
5    2
ÊäÈë0ÏÖÔÚÏëµÃµ½
4 5
Ò²¾ÍÊÇ»ñÈ¡Ò¶×ӽڵ㣬¸ÄÔõôʵÏÖ£¿ лл

---

http://blog.csdn.net/wufeng4552/archive/2009/09/30/4619995.aspx

---

ÎÒÒªµÄÊÇÒ¶×ӽڵ㣬¾ÍÊÇ×îµ×²ãµÄ½Úµã

---

0 µÃµ½4,5 ?

---

ÒýÓÃ

http://blog.csdn.net/wufeng4552/archive/2009/09/30/4619995.aspx

Õâ¸öºÃ

---

BOM¡¡¾«»ª

---

¶Ô 0 µÃµ½ 4 5

---

SQL code:
-->Title:Generating test data
-->Author:wufeng4552
-->Date :2009-09-30 14:27:56

if not object_id('tb') is null
drop table tb
Go
Create table tb([id] int,[parentid] int,[name] varchar(10))
Insert tb
select 1,0,null union all
select 2,0,null union all
select 3,1,null union all
select 4,3,null union all
select 5,2,null
Go
-->Title:²éÕÒÖ¸¶¨節點ϵÄ×Ó結點
if object_id('Uf_GetChildID')is not null drop function Uf_GetChildID
go
create function Uf_GetChildID(@ParentID int)
returns @t table(ID int)
as
begin
insert @t select ID from tb where ParentID=@ParentID
while @@rowcount<>0
begin
insert @t select a.ID from tb a inner join @t b
on a.ParentID=b.id and
not exists(select 1 from @t where id=a.id)