select id=number from master..spt_values where type='p' and number between 1 and 100 
 union all 
 select id=number from master..spt_values where type='p' and number between 1 and 100 
 union all 
 select id=number from master..spt_values where type='p' and number between 1 and 100 order by id 
 /* 
 id 
 ----------- 
 1 
 1 
 1 
 2 
 2 
 2 
 3 
 3 
 3 
 4 
 4 
 4 
 5 
 5 
 5 
 6 
 6 
 6 
 7 
 7 
 7 
 8 
 8 
 8 
 9 
 9 
 9 
 10 
 10 
 10 
 11 
 11 
 11 
 12 
 12 
 12 
 13 
 13 
 13 
 14 
 ...... 
 92 
 93 
 93 
 93 
 94 
 94 
 94 
 95 
 95 
 95 
 96 
 96 
 96 
 97 
 97 
 97 
 98 
 98 
 98 
 99 
 99 
 99 
 100 
 100 
 100 
  
 (300 行受影响) 
  
 */