sql生成1000W数据

来源：互联网发布：服务器端编程技术编辑：程序博客网时间：2024/05/01 18:40

declare @d datetimeset @d=getdate()select * from dbo.ChunkSegmentMappingselect [语句执行花费时间(毫秒)]=datediff(ms,@d,getdate())USE tempdbGOCREATE TABLE tb(id char(8))CREATE UNIQUE INDEX IX_tb ON tb(id)WITH IGNORE_DUP_KEY  -- --忽略重复记录的索引GODECLARE @dt datetimeSET @dt = GETDATE()SET NOCOUNT OFFDECLARE @row intSET @row = 1000000 --记录总数为WWHILE @row >0BEGIN RAISERROR('need %d rows', 10, 1, @row) WITH NOWAIT SET ROWCOUNT @row INSERT tb SELECT id = RIGHT(100000000 + CONVERT(bigint, ABS(CHECKSUM(NEWID()))), 8) --FROM syscolumns c1, syscolumns c2  -- SET NOCOUNT ON 49 Second FROM syscolumns c1, sysobjects o -- SET NOCOUNT ON 47 Second SET @row = @row - @@ROWCOUNT  --设置下次循环需要插入的记录数量ENDSELECT BeginDate = @dt, EndDate = GETDATE(), Second = DATEDIFF(Second, @dt, GETDATE())GOSELECT COUNT(*) FROM tbGOSELECT * FROM tbDROP TABLE tb

0 0