有时候处于测试要求，需要在数据库里快速插入大批量连续数字，下面是实现语句。

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

关键词：批量  插入  数字  快速  连续