sql如何获取一个时间段内的月份

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

*/