//TableName 表名 ParentID 父节点 ; WITH ret AS(SELECT * FROM SysBest_Role WHERE ID = Parentid UNION ALL SELECT t.* FROM TableName t INNER JOIN ret r ON t.ParentID = r.ID) SELECT * FROM ret w
Tree 通过父id找所有子节点
原文：http://www.cnblogs.com/tangpeng97/p/8004242.html
