34,576
社区成员
发帖
与我相关
我的任务
分享
select TOP 10000 rn=identity(int),id=newid() into # from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e
select ABS(CHECKSUM(ID))
from # a
where NOT exists(
select 1
from #
where id=a.id
and rn<>a.rn)
SELECT CONVERT(INT,ABS(CHECKSUM(CONVERT(BINARY,NEWID()))),8)
create table TimeSquare_Code(id bigint identity(1,1) PRIMARY KEY CLUSTERED,code bigint,status int default 0)
go
create procedure sp_TimeSquare_randomcode
as
insert into timesquare_Code(code)
select top 1000000 code=900000000000*RAND(CHECKSUM(NEWID()))+100000000000 from syscolumns a,syscolumns b,syscolumns c
go
exec sp_timesquare_randomcode
go
select * from timesquare_code
go
drop table timesquare_code
drop procedure sp_TimeSquare_randomcode
declare @n int
set @n=? --n位
select top 1000000 left(abs(checksum(newid())),@n) as id
from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e
select top 1000000 abs(checksum(newid())) as id
from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e
--随即生成100W不重复的6位数。
select top 1000000 left(abs(checksum(newid())),6) from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e
--用时8秒。
select top 1000000 checksum(newid()) *1000000
from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e
select top 1000000 newid() from syscolumns a ,syscolumns b,syscolumns c,syscolumns d,syscolumns e