下面所介绍的思想可用于.Net,Java
create proc getDays
@date1 datetime
@date2 datetime
as
begin
create table #dtday(aday datetime)
select @date1=dateadd(d,1,@date1)
while @date1<@date2
begin
insert into #dtday values(@date1)
select @date1=dateadd(d,1,@date1)
end
select * from #dtday
drop table #dtday