--100次递归
with cte1 as
(
select 1 i
),cte3 as
(
select i from cte1
union all
select i+1 i from cte3 where
i < 100
)
select * from cte3
--spt_value,只到2047
select number+1 from master..spt_values where type='P'
with cte1 as
(
select 1 i
),cte3 as
(
select i from cte1
union all
select i+1 i from cte3 where
i < 100
)
select * from cte3
--spt_value,只到2047
select number+1 from master..spt_values where type='P'