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

posted on 2013-01-02 12:08  一个石头  阅读(190)  评论(0编辑  收藏  举报