getfullpath.sql

实现表结构为 ID

CREATE        FUNCTION FullClassPath (@ClassID  int)  
RETURNS nvarchar(4000) AS  
BEGIN 

 DECLARE @temPath nvarchar(4000)
 DECLARE @temID int
 select  @temPath =name,@temID=parentid from patentclass where id = @ClassID
 if (@temID is null)
  return @temPath;
 else
  begin
	
	while(not (@temid is null))
	begin
		select @temPath = name +'\' + @temPath,@temID=parentid from patentclass where id = @temID
	
		
	end
  end
 
 return @temPath
END