select number from master..spt_values where type='p'

--0~2047 共2048个数字  
.SELECT number FROM MASTER..spt_values WHERE  TYPE = 'p'  

 

输出时间段内的日期

declare @begin datetime,@end datetime
set @begin='2012-1-1'
set @end='2012-1-5'

declare @days int
set @days=DATEDIFF(dd,@begin,@end)
select DATEADD(dd,number,@begin)
from master.dbo.spt_values
where type='p' AND number<=@days

结果：

2012-01-01 00:00:00.000
2012-01-02 00:00:00.000
2012-01-03 00:00:00.000
2012-01-04 00:00:00.000
2012-01-05 00:00:00.000