with ChildMenu as(
select * from MemberMenu where MenuId='F31E3D26-BB08-42C0-A171-EF62243A94C6'
union all
select MemberMenu.* from MemberMenu inner join ChildMenu on MemberMenu.ParMenuId=ChildMenu.MenuId
)
select * from ChildMenu
with ChildMenu as(
select * from MemberMenu where MenuId='F31E3D26-BB08-42C0-A171-EF62243A94C6'
union all
select MemberMenu.* from MemberMenu inner join ChildMenu on MemberMenu.ParMenuId=ChildMenu.MenuId
)
select * from ChildMenu
转载于:https://www.cnblogs.com/caizhiyuan/archive/2011/12/06/2277669.html