用while循环插入测试数据（SQL Server2005）
1
declare @index int;
2set @index = 2000;
3
4while(@index < 2011)
5begin
6 insert pt_result_part_class_process_avg_time values(
7 newid(),@index,200,500,150,106,120,55,726,newid(),'2008-01-01',newid(),'2008-01-09',
8 0,0,'true')
9 set @index = @index + 1
10end
declare @index int;2
set @index = 2000;3
4
while(@index < 2011)5
begin6
insert pt_result_part_class_process_avg_time values(7
newid(),@index,200,500,150,106,120,55,726,newid(),'2008-01-01',newid(),'2008-01-09',8
0,0,'true')9
set @index = @index + 110
end
浙公网安备 33010602011771号