select convert(varchar(7),dateadd(month,number,‘2010-01-01‘),120) from master..spt_values where type=‘P‘ and dateadd(month,number,‘2010-01-01‘)<=‘2010-09-01‘ /* ------- 2010-01 2010-02 2010-03 2010-04 2010-05 2010-06 2010-07 2010-08 2010-09 */
原文：http://www.cnblogs.com/shenyixin/p/5180961.html