sqlserver - ダミーデータ作成

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