产生 10000 条连续记录
PRINT CONVERT(VARCHAR(50), GETDATE(), 21)
select id = a.id + b.id + c.id + d.id + 1
from(
select id = 0
union all select 1
union all select 2
union all select 3
union all select 4
union all select 5
union all select 6
union all select 7
union all select 8
union all select 9
) a
,(
select id = 0
union all select 10
union all select 20
union all select 30
union all select 40
union all select 50
union all select 60
union all select 70
union all select 80
union all select 90
) b
,(
select id = 0
union all select 100
union all select 200
union all select 300
union all select 400
union all select 500
union all select 600
union all select 700
union all select 800
union all select 900
) c
,(
select id = 0
union all select 1000
union all select 2000
union all select 3000
union all select 4000
union all select 5000
union all select 6000
union all select 7000
union all select 8000
union all select 9000
) d
order by id
PRINT CONVERT(VARCHAR(50), GETDATE(), 21)
