连续编号.sql

来自「这是CSDN SQL Server 版主邹建的SQL笔记」· SQL 代码 · 共 27 行

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