set rowcount 1000 select identity(int,0,1) as id into #t from sysobjects a,sysobjects b set rowcount 0select dateadd(day , id ,cast('2005-01-01' as datetime)) from #t where id <= datediff(day , '2005-01-01' , '2005-09-10')
declare @StartTime as datetime,@EndTime as datetimeset @StartTime='2005-01-01' set @EndTime ='2005-09-10' declare @t table(dDate datetime) --计算连续时间 while @StartTime<=@EndTime begin insert into @t select @StartTime set @StartTime=Dateadd(day,1,@StartTime) end
select identity(int,0,1) as id into #t from sysobjects a,sysobjects b
set rowcount 0select
dateadd(day , id ,cast('2005-01-01' as datetime))
from
#t
where
id <= datediff(day , '2005-01-01' , '2005-09-10')
set @EndTime ='2005-09-10'
declare @t table(dDate datetime) --计算连续时间
while @StartTime<=@EndTime
begin
insert into @t select @StartTime
set @StartTime=Dateadd(day,1,@StartTime)
end