执行以下sql:
select convert(varchar(7),dateadd(month,number,'2016-01-01'),120) report_period from master..spt_values where type='P' and dateadd(month,number,'2016-01-01')<='2017-07-01'
执行以下sql:
select convert(varchar(7),dateadd(month,number,'2016-01-01'),120) report_period from master..spt_values where type='P' and dateadd(month,number,'2016-01-01')<='2017-07-01'
转载于:https://my.oschina.net/u/3653197/blog/1532022