SQL Server 高效批量生成自然数

WITH B1 AS (SELECT 1 n UNION ALL SELECT 1)                                                -- 2
   , B2 AS (SELECT 1 n FROM B1 l CROSS JOIN B1 r)                                         -- 4
   , B4 AS (SELECT 1 n FROM B2 l CROSS JOIN B2 r)                                         -- 16
   , B8 AS (SELECT 1 n FROM B4 l CROSS JOIN B4 r)                                         -- 256
   , B16 AS (SELECT 1 n FROM B8 l CROSS JOIN B8 r)                                        -- 65536
   , B20 AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) r FROM B16 l CROSS JOIN B4 r) -- 65536 * 16
SELECT TOP 1000000 B20.r FROM B20 ORDER BY B20.r;