sqlserver 循环插入数据

  --循环执行插入50000条数据
declare @ID int
declare @channelid int
declare @categoryid int
declare @title nvarchar(100)
declare @content nvarchar(255)
declare @status int
declare @username nvarchar(16)
declare @add_time datetime
begin
set @ID=1
set @channelid=6
set @categoryid=5
set @title='测试循环执行'
set @content='循环执行内容'
set @status=0
set @username='admin'
set @add_time=GETDATE()

while @ID<=50000
begin 
insert into [DTcmsdb4].[dbo].[dt_article]([channel_id],[category_id],[title],[content],[status],[user_name],[add_time])
values(@channelid,@categoryid,@title,@content,@status,@username,@add_time)
set @ID=@ID+1
set @add_time=GETDATE()
end

end
复制