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
sql 存储过程批量插入数据
作者:
小新
发布于 2019-12-31 | 最后更新 2019-12-31