可以使用以下语句:
declare @Year_t as varchar(4)--声明变量
set @Year_t=cast((cast(convert(varchar(4),getdate(),120) as int)-1) as varchar(4))--依据系统时间获得上一年的年份
select top 12 dateadd(dd,-1,dateadd(m,1,@Year_t+'-'+cast((row_number() over(order by object_id)) as varchar(2))+'-01')) from sys.all_columns
结果是: