SQL百万级别随机数批量生成

SQL百万级别随机数批量生成

CREATE TABLE tb(id varchar(12))
CREATE UNIQUE INDEX IX_tb ON tb(id)
WITH IGNORE_DUP_KEY -- --忽略重复记录的索引
GO

SET NOCOUNT OFF
DECLARE @row int
SET @row = 1000000 --记录总数为100W

WHILE @row >0
BEGIN
　　SET ROWCOUNT @row

　　INSERT tb SELECT left(convert(varchar(20), ABS(CHECKSUM(NEWID())))+ '00000000', 8)
　　FROM syscolumns c1, sysobjects o

　　SET @row = @row - @@ROWCOUNT
END
GO

--SELECT COUNT(*) FROM tb

SET ROWCOUNT 0
SELECT id FROM tb

GO