SQL2005的cte递归查询子树 ;with cteas(select id,caption,parentid,1 Gen from skywfflow where parentid =0UNION ALL select a.id,a.caption,a.parentid,cte.gen+1 Gen from skywfflow a inner join cte on a.parentid=cte.id)select * from cte