输出2个日期间的日期

输出2个日期间的日期

declare @start	datetime 
declare @end	datetime 
set @start = '2013-09-25' 
set @end = '2013-09-30' 

select dateadd(dd,num,@start) 
FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK
where dateadd(dd,num,@start) <=@end 


/*
结果：
2013-09-25 00:00:00.000
2013-09-26 00:00:00.000
2013-09-27 00:00:00.000
2013-09-28 00:00:00.000
2013-09-29 00:00:00.000
2013-09-30 00:00:00.000
*/