SqlServer递归查询

with ct ---定义一个公用表 ct, 用于递规查询。
as (
    select * from MainMenuTree where cMenuID='01'  ---根节点条件
    union all
    select b.* from ct inner join MainMenuTree b 
        on b.cParentID= ct.cMenuID  ---子节点递规条件 
 ) select * from ct;