[SQL Server]sql递归查询子目录

sql递归查询子目录
 
function c_tree(@initid char(36))/*定义函数c_tree，输入参数为初始节点id*/
returns @t table(id char(36),name varchar(100),ParentId char(36))/*定义表t用来存放取出的数据*/
begin
  insert @t select id,name,ParentId from ET_TrainingDirectory where ParentId=@initid
  while @@rowcount>0
  begin
insert into @t select A.ParentID,A.ID,A.name
   from ET_TrainingDirectory A inner join @t B on A.ParentID=B.ID
  end
return
end
 
select * from c_tree('7E331cad-4F62-4F08-98E9-5BF7FDAADD71')