使用sql计算两个时间之间的月份

create table #tmp_m (mon datetime)

declare @sDate datetime
declare @eDate datetime
set @sDate = '2023-04-09'
set @eDate = '2023-06-05'
declare @m int
set @m=0
while @m<=datediff(m,@sDate,@eDate)
begin
    insert into #tmp_m values (dateadd(mm,@m,@sDate))
    select dateadd(mm,@m,@sDate)
    set @m += 1
end
select * from #tmp_m