declare @a int set @a = 1 while @a<1000000 begin insert into Test(name) values(@a) set @a = @a + 1 end