http://expert.csdn.net/Expert/topic/1375/1375432.xml?temp=.8570978--------------------------------
select dbo.fn_gettopclass(tc_id,'',2) from treeclass order by dbo.fn_gettopclass(tc_id,'',1)
select dbo.fn_gettopclass(tc_id,'',2) from treeclass order by dbo.fn_gettopclass(tc_id,'',1)
更正:
select *,dbo.fn_32gettopclass(Tc_id,default,2,default) from treeclass order by dbo.fn_32gettopclass(Tc_id,default,2,default)