SELECT CONVERT(varchar(6),DATEADD(month,number,'20130101'),112) AS [Date]
FROM master.dbo.spt_values
WHERE type = 'p'
AND DATEADD(month,number,'20130101') <= '20130501';
查询结果:
date
201301
201302
201303
201304
201305
SELECT CONVERT(varchar(6),DATEADD(month,number,'20130101'),112) AS [Date]
FROM master.dbo.spt_values
WHERE type = 'p'
AND DATEADD(month,number,'20130101') <= '20130501';
查询结果:
date
201301
201302
201303
201304
201305