Sql Server递归查找某一节点下面所有子节点
摘要: with ChildMenu as(select * from MemberMenu where MenuId='F31E3D26-BB08-42C0-A171-EF62243A94C6'union allselect MemberMenu.* from MemberMenu inner join ChildMenu on MemberMenu.ParMenuId=ChildMenu.MenuId)select * from ChildMenu
阅读全文
posted @
2011-12-06 10:57 @清风...... 阅读(53) |
评论 (0) 编辑