34,588
社区成员
发帖
与我相关
我的任务
分享列举路径
表T
ID Folder ParentID
1 AA 0
2 BB 1
3 CC 1
4 DD 3
已经知道ID=4
求结果
AA\CC\DD
ID Folder ParentID
1 AA 0
2 BB 1
3 CC 1
4 DD 3
已经知道ID=4
求结果
AA\CC\DD
...全文
请发表友善的回复…
发表回复
愉快的登山者 2003-03-10
- 打赏
- 举报
drop table #T
create table #T
(id int,
folder varchar(5),
parentid int
)
insert into #T values (1,'AA',0)
insert into #T values (2,'BB',1)
insert into #T values (3,'CC',1)
insert into #T values (4,'DD',3)
declare @id int
set @ID=4
declare @path varchar(20)
select @path = folder, @id = parentid from #T where id = @id
while @id > 0
select @path = folder + '\'+@path, @id = parentid from #T where id = @id
select @path
AA\CC\DD
create table #T
(id int,
folder varchar(5),
parentid int
)
insert into #T values (1,'AA',0)
insert into #T values (2,'BB',1)
insert into #T values (3,'CC',1)
insert into #T values (4,'DD',3)
declare @id int
set @ID=4
declare @path varchar(20)
select @path = folder, @id = parentid from #T where id = @id
while @id > 0
select @path = folder + '\'+@path, @id = parentid from #T where id = @id
select @path
AA\CC\DD
