use sandbox declare @index int; set @index = 0; while @index < 100000 begin print @index; set @index = @index + 1; insert into TestTable (id, name) values (@index, 'name' + CAST(@index as nvarchar)) end -- select * from TestTable -- truncate table TestTable