declare @starttime datetime,@Endtime datetime
set @starttime='2005-10-1'
set @Endtime='2005-11-4'
declare @t table(datetimes datetime)
while @starttime<=@Endtime
begin
insert into @t select @starttime
set @starttime=dateadd(day,1,@starttime)
end
select * from @t
set @starttime='2005-10-1'
set @Endtime='2005-11-4'
declare @t table(datetimes datetime)
while @starttime<=@Endtime
begin
insert into @t select @starttime
set @starttime=dateadd(day,1,@starttime)
end
select * from @t
select convert(varchar(10),datetimes,120) from @t