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<DATEDIFF(day, @date, dateadd(month, 1, @date))
begin
print convert(varchar(10), dateadd(day, @i, @date), 120)
set @i=@i+1
END
03-15
1105
05-23