向数据库表循环插入数据
--delete from [table]
DECLARE @step int
DECLARE @i int
select top(1) @i = Code from [table] order by Code desc
if (@i is NULL)
set @i=1
else
set @i = @i + 1
set @step=@i+50
WHILE @i<@step
BEGIN
insert [dbo].[table]([field],[field],[field],[field],[field],[field],[field],[field],[field]) values(@i,'test'+convert(char(10), @i) ,'2020-08-03 08:39:10.183','2021-08-31 08:39:10.183','test','test',1,8,null)
SET @i=@i+1
END
--select * from [table]