日期:2014-05-17 浏览次数:20523 次
select 1 ID ,0 HasChild ,1 Lev
into #temp
union all select 2 ,0 ,1
union all select 3 ,2 ,2
union all select 4 ,2 ,2
union all select 5 ,3 ,3
union all select 6 ,0 ,1
union all select 7 ,0 ,1
union all select 8 ,0 ,1
union all select 9 ,0 ,1
union all select 10 ,0 ,1
union all select 11 ,10 ,2
union all select 12 ,0 ,1
union all select 13 ,12 ,2
union all select 14 ,0 ,1
union all select 15 ,14 ,2
declare&nb