--------------------------找出在2个日期之间的日期----------------------

declare @sdate datetime
declare @edate datetime
set @sdate = '2009-8-30'
set @edate = '2009-9-5'


select
    dateadd(dd,num,@sdate)
from
    (select isnull((select count(1) from sysobjects where id <t.id),0) as num from sysobjects t) a
where
    dateadd(dd,num,@sdate) <=@edate

/*
                                                     
------------------------------------------------------
2009-08-30 00:00:00.000
2009-08-31 00:00:00.000
2009-09-01 00:00:00.000
2009-09-02 00:00:00.000
2009-09-03 00:00:00.000
2009-09-04 00:00:00.000
2009-09-05 00:00:00.000

（所影响的行数为 7 行）
*/

 

 

--功能：找出在2个日期之间的日期
--startdate:2009年9月15日  endDate:2009年10月3日

declare @startdate datetime,@enddate datetime
set @startdate='2009-08-30'
set @enddate='2009-09-05'

select convert(varchar(10),dateadd(day,number,@startdate),120)
from
    master..spt_values
where
    datediff(day,dateadd(day,number,@startdate), @enddate)>=0
    and number>0
    and type='p'

/*----------
2009-08-31
2009-09-01
2009-09-02
2009-09-03
2009-09-04
2009-09-05

(6 行受影响)

/*