Sqlserver generates 1 million non-repeated 10-bit random numbers and stores them in the database.

Use tempdb

Go

Create Table randomnumber (ID char (10), isused bit not null)
Create unique index ix_randomnumber on randomnumber (ID)
With ignore_dup_key
Go

Declare @ DT datetime
Set @ dt = getdate ()
Set nocount on
Declare @ row int
Set @ ROW = 1000000
While @ row> 0
Begin
Raiserror ('need % d rows ', 10, 1, @ row) with Nowait
Set rowcount @ row
Insert randomnumber select
Id = right (10000000000 + convert (bigint, ABS (checksum (newid (), 10)
, Isused = 0
From syscolumns C1, sysobjects o --, syscolumns C2
Set @ ROW = @ row-@ rowcount
End
Select begindate = @ DT, enddate = getdate (), second = datediff (second, @ DT, getdate ())
Go

Select count (*) from randomnumber
Go

-- Drop table randomnumber