sqlserver快速插入1000000个连续的数字

with
l0 as (select 1 as C union all select 1 as C),--2-1
l1 as (select 1 as C from l0 as A,l0 as B),--2-2
l2 as (select 1 as C from l1 as A,l1 as B),--2-4
l3 as (select 1 as C from l2 as A,l2 as B),--2-16
l4 as (select 1 as C from l3 as A,l3 as B),--2-256
l5 as (select 1 as C from l4 as A,l4 as B)--2-256^2
select ROW_NUMBER () over (order by C) as n into Nums from l5