sqlserver数据库 如何循环日期获取年和月
发布网友
共1个回答
热心网友
也用不着存储过程啊，直接运行下边
with t as(select number rn from master..spt_values where type='p')
select
convert(varchar(7),dateadd(month,rn,CAST('2015-01-01' as datetime)),120) from t where
dateadd(month,rn,CAST('2015-01-01' as datetime))<=CAST('2015-12-31' as datetime)
