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 @pathAA\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 @pathAA\CC\DD
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货