declare @beginDate datetime
declare @endDate datetime
set @beginDate = '2010-11-1'
set @endDate = '2011-1-2'
create table #temp(ids int identity(1,1), 日期 nvarchar(10))
declare @i int
set @i = 0
while @i <=datediff(dd,@beginDate,@endDate)
begin
insert into #temp
select convert(nvarchar(11), dateadd(dd,@i,@beginDate),120)
set @i = @i +1
end
select * from #temp