循环向表中加入测试数据

1.

declare   @i   int  
  set   @i=10  
  while   @i<20  
  begin  
      insert   into   ceshitwo(Title,Author,Source)  
      values('Title'+cast( @i as varchar),'Author'+cast( @i as varchar),'Source'+cast( @i as varchar))  
      set   @i=@i+1  
  end  

2.

declare @index int;
set @index = 2000;

 while(@index < 2011)
 begin
     insert pt_result_part_class_process_avg_time values(
     newid(),@index,200,500,150,106,120,55,726,newid(),'2008-01-01',newid(),'2008-01-09',
     0,0,'true')
     set @index = @index + 1
end