declare @i int set @i=0 while (@i<100000) begin insert into table values(@i,GETDATE(),3) set @i=@i+1 end