sql server T-SQL while 循环 插入数据

 向数据库表循环插入数据

  
--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]