用while循环插入测试数据(SQL Server2005)
1
declare @index int;
2
set @index = 2000;
3![](/Images/OutliningIndicators/None.gif)
4
while(@index < 2011)
5
begin
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
10
end
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/None.gif)
9
![](/Images/OutliningIndicators/None.gif)
10
![](/Images/OutliningIndicators/None.gif)