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')