if object_id('MyDB.dbo.Numbers') is not null    drop table MyDB.dbo.Numbersgouse [MyDB]gocreate table dbo.Numbers(ID INT NOT NULL)gocreate unique clustered index ix_uniq_clst_numbers_id on dbo.Numbers(id)gowith t as (select row_number() over (order by col1) as rowno from (select top 1000000 1 as col1from sys.syscolumns a, sys.syscolumns b, sys.syscolumns c) t)insert into dbo.Numbers select rowno from t order by rowno