学步园

declare @date datetime<br /> set @date='2009-02-05'</p> <p>select [day]=convert(varchar,DATEADD(mm,DATEDIFF(mm,0,@date),0)+number,112)<br /> from master..spt_values<br /> where type='p'<br /> and number< datediff(dd,@date,dateadd(mm,1,@date))</p> <p>/*<br /> day<br /> 20090201<br /> 20090202<br /> 20090203<br /> 20090204<br /> 20090205<br /> 20090206<br /> 20090207<br /> 20090208<br /> 20090209<br /> 20090210<br /> 20090211<br /> 20090212<br /> 20090213<br /> 20090214<br /> 20090215<br /> 20090216<br /> 20090217<br /> 20090218<br /> 20090219<br /> 20090220<br /> 20090221<br /> 20090222<br /> 20090223<br /> 20090224<br /> 20090225<br /> 20090226<br /> 20090227<br /> 20090228<br /> */</p> <p>DECLARE @d1 DATETIME, @d2 DATETIME<br /> SELECT @d1 = '2010-01-01', @d2 = '2010-05-31' </p> <p>SELECT [day] = CONVERT(VARCHAR, DATEADD(dd, number, @d1), 23)<br /> FROM MASTER..spt_values<br /> WHERE TYPE = 'p'<br /> AND number<= DATEDIFF(dd, @d1, @d2)<br /> /*<br /> day<br /> ------------------------------<br /> 2010-01-01<br /> 2010-01-02<br /> 2010-01-03<br /> 2010-01-04<br /> 2010-01-05<br /> 2010-01-06<br /> 2010-01-07<br /> 2010-01-08<br /> 2010-01-09<br /> ......<br /> 2010-05-25<br /> 2010-05-26<br /> 2010-05-27<br /> 2010-05-28<br /> 2010-05-29<br /> 2010-05-30<br /> 2010-05-31</p> <p>(151 行受影响)<br /> */</p> <p>