--example 1:
DECLARE @pid INT,@name NVARCHAR(50),@level INT,@i INT,@column2 INT
SET @pid=0
SET @name ='first'
SET @level =5
SET @column2=0
SET @i=0
WHILE @i<30 --30为你要执行插入的次数
BEGIN
INSERT INTO table_name ( pid, name,level, column2)
VALUES ( @pid, @name,@level,@column2)
SET @i=@i+1
END
--example2:
DECLARE @id1 INT,@id2 INT, @name nchar(20),@starttime BIGINT,@i INT,@endtime BIGINT
SET @id1=0
SET @id2=0
SET @name ='first'
SET @starttime =1532576049
SET @endtime=1532832275
SET @i=0
WHILE @i<10
BEGIN
SET @id2=@id2+1
INSERT INTO table_name ( id1, id2, name,starttime, endtime)
VALUES ( @id1, @id2, @name,@starttime,@endtime)
SET @i=@i+1
END