sql server2012，cte递归、表变量递归实现层级结构数据。

--cte结构递归
set statistics time off ;
set statistics io off;
with ctea
as (select CODE
         , NAME
         , LEVELNO
         , PCODE
    from [dbo].[T_PUBEXPFUNC])
   , cteb
as (select a.CODE
         , a.NAME
         , a.LEVELNO
         , a.PCODE
         , cast(a.NAME as nvarchar(1000)) as full_name
    from ctea as a
    where a.LEVELNO = 1
    union all
    select s.CODE