SQL Server ->> 生成Numbers辅助表

if object_id('MyDB.dbo.Numbers') is not null
    drop table MyDB.dbo.Numbers
go

use [MyDB]
go

create table dbo.Numbers(ID INT NOT NULL)
go

create unique clustered index ix_uniq_clst_numbers_id on dbo.Numbers(id)
go

with t as (
select row_number() over (order by col1) as rowno from (
select top 1000000 1 as col1
from sys.syscolumns a, sys.syscolumns b, sys.syscolumns c) t
)

insert into dbo.Numbers select rowno from t order by rowno

 

转载于:https://www.cnblogs.com/jenrrychen/p/4663685.html