SQL获取当前年月的每一天

DECLARE  @Mouth NVARCHAR(50)='',
@Year NVARCHAR(50)='',
@StartDate DATETIME=null,
@EndDate DATETIME=NULL
SET @Year= (SELECT DATENAME(YEAR,GETDATE()))  --获取当前年
SET @Mouth=(SELECT DATENAME(MONTH,GETDATE()))  --获取当前月
declare @s varchar(6)
 set @s=@Year+@Mouth
 
 declare @date smalldatetime
 set @date=@s+'01'
 
 declare @i smallint
 set @i=0
 while @i  begin
     print convert(varchar(10), dateadd(day, @i, @date), 120)
     set @i=@i+1
 END