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