开始结束日期之间的全部日期列表

select format(dateadd(dd,number,'2021-05-01'),'MM月dd日') AS date 

from master..spt_values 

where type='p' and dateadd(dd,number,'2021-05-01')<='2021-05-10'