求一个SQL语句

Question

语句就一个时间列 
 .
 .
 .
 2012-02-15
 2012-02-16
 .
 .
 .
类似于自增长的主键一样，按天自增长
起始时间给个古老点的，2000-01-01就行了
，差不多增长个几十年就OK了

Answer 1

--sql 2000
declare @sdate datetime
declare @edate datetime
set @sdate = '2000-01-01'
set @edate = '2050-01-01'select num = identity(int,0,1) into tmp from sysobjects m , sysobjects n , sysobjects tselect 
    dateadd(dd,num,@sdate) dt
from 
    tmp a
where
    dateadd(dd,num,@sdate)<=@edatedrop table tmp/*
dt                                                     
------------------------------------------------------ 
2000-01-01 00:00:00.000
2000-01-02 00:00:00.000
2000-01-03 00:00:00.000
2000-01-04 00:00:00.000
2000-01-05 00:00:00.000
2000-01-06 00:00:00.000
2000-01-07 00:00:00.000
2000-01-08 00:00:00.000
2000-01-09 00:00:00.000...2049-12-25 00:00:00.000
2049-12-26 00:00:00.000
2049-12-27 00:00:00.000
2049-12-28 00:00:00.000
2049-12-29 00:00:00.000
2049-12-30 00:00:00.000
2049-12-31 00:00:00.000
2050-01-01 00:00:00.000（所影响的行数为 18264 行）*/