我编写了一个SQL函数，该函数应返回您要查找的内容。
create table Folders ( FolderID int, FolderName varchar(10), ParentID int)insert into Folders (FolderID, FolderName, ParentID) select 1,'Folder1',0 union all select 2,'Folder2',1 union all select 3,'Folder3',2 union all select 4,'Folder4',3 gocreate function dbo.CreateFolderPath (@FolderID int)returns varchar(1000)asbegin declare @ParentID int declare @FolderPath varchar(1000) set @FolderPath = '' select @ParentID = ParentID from Folders where FolderID = @FolderID while @ParentID<>0 begin select @FolderPath = FolderName + '' + @FolderPath, @ParentID = ParentID from Folders where FolderID = @ParentID end return @FolderPathend goselect dbo.CreateFolderPath(4)drop function dbo.CreateFolderPathdrop table Folders
