oracle获取连续月份,sql server2008如何获取连续月份？

declare @starttime datetime,@endtime datetime

set @starttime = '2013-07-01'

set @endtime ='2013-10-31'

declare @startYear int,@startMonth int ,@endYear int,@endMonth int

--set @startYear=DatePart(yyyy,@starttime)

set @startMonth=DatePart(M,@starttime)

--set @endYear=DatePart(M,@endtime);

set @endMonth=DatePart(M,@endtime)

create table #tmpStudent(alltime varchar(20))

declare @time varchar(20)

while(@startMonth<=@endMonth)

begin

set @time='2013'+'-'+cast(@startMonth as varchar(10))

insert into #tmpStudent values(@time)

set @startMonth=@startMonth+1

end

select * from #tmpStudent

drop table #tmpStudent