SQLServer循环插入100万条记录 - 牧人池塘 - DBA杂谈录

2021-10-20

暂无评论

SQLServer循环插入100万条记录

CREATE TABLE [dbo].[task] (
  [taskid] int  IDENTITY(1,1) NOT NULL,
  [taskname] nvarchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [createdtime] datetime  NULL,
  CONSTRAINT [PK__task__DD5E468A1F5BD1F5] PRIMARY KEY CLUSTERED ([taskid])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)  
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[task] SET (LOCK_ESCALATION = TABLE)

开始循环插入：

declare @num int
 set @num =0
 while(@num<1000000)
 begin 
 set @num = @num+1
  insert dbo.task (taskname,createdtime) values('测试', GETDATE())
END

该方法用于快速插入测试数据，进行性能测试·

Tag标签:「记录循环」更新时间:「2021-11-15 11:13:20」阅读次数:「934」

相关博文：