sql 获取连续年份

1

    SELECT [year] AS [value],[year] AS label FROM (
    SELECT FORMAT(DATEADD(YEAR,-number,GETDATE()),'yyyy') AS [year] FROM master.dbo.spt_values WHERE type='p' and number<10) AS t