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
我不忙,泡你不如泡面
一个不爱写博客的程序员博客
一个不爱写博客的程序员博客
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
