sql 批量插入数据

declare @index int
set @index = 0
while(@index<1000000)
begin
insert into [table]([name]) values(FLOOR(RAND(ABS(CHECKSUM(NEWID())))*1000))
set @index = @index +1
end