Sql Server中通過父記錄查找出所有關聯的子記錄

　　可查級Sql代碼

　　select menu_idmenu_nameFather_Id from Sys_Menu where menu_id= or Father_Id= or 一級二級 Father_Id in (select menu_id from Sys_Menu a where menu_id= or Father_Id=) or 三級 father_id in (select menu_id from sys_menu where Father_Id in (select menu_id from Sys_Menu a where menu_id= or Father_Id=)) 四級

From:http://tw.wingwit.com/Article/program/SQLServer/201311/22309.html