sql将两个日期之间的日子全列出来

select dateadd(dd,num,@begintime) FROM (SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects) KK where dateadd(dd,num,@begintime) <=@endtime