日期:2014-05-17 浏览次数:20380 次
/*SortTree,SortChild表中并不存在*/ select NavID,NavName,ParentID,Sort,SortTree = case when ParentID=0 then NavID else ParentID end ,SortChild=ParentID+Sort from Navigation order by SortTree,SortChild,ParentID