SQLSERVER 递归查询

DECLARE @MenuID INT=10--递归菜单ID=10的所有父级/子级节点，包含自己;WITH dtMenuNodes AS(SELECT * FROM dbo.tbl_SoleHome_Menu WHERE MenuID=@MenuIDUNION ALL--SELECT a.* FROM tbl_SoleHome_Menu a,dtMenuNodes WHERE a.ParentID=dtMenuNodes.MenuID--所有子级节点SELECT a.* FROM tbl_SoleHome_Menu a,dtMenuNodes WHERE a.MenuID=dtMenuNodes.ParentID--所有父级节点)SELECT * FROM dtMenuNodes ORDER BY dtMenuNodes.ParentID ASC