sql 存储过程批量插入数据

作者: 小新

发布于 2019-12-31 | 最后更新 2019-12-31


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