/*最近总是遇到需要大数据的时候，总是没有，所以准备了一点*/
create procedure InsertTest2
as
begin
declare @v_num int;
set @v_num=100
while @v_num < 1000000
begin
insert into shop_worktime (shopid,StandardETime,StandardSTime) values (@v_num,2015-05-20,2017-06-05)
set @v_num=@v_num+1
end
end
通过变量 v_num 控制