12 2011 档案
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
阅读全文
浙公网安备 33010602011771号