用while循环插入测试数据(SQL Server2005)
1declare @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
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