1)获取去年一年的年月日的SQL:
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 12, getdate()),
120
) sj,YEAR(dateadd(mm ,- 12, getdate())) year,MONTH(dateadd(mm ,- 12, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 11, getdate()),
120
) sj,YEAR(dateadd(mm ,- 11, getdate())) year,MONTH(dateadd(mm ,- 11, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 10, getdate()),
120
) sj,YEAR(dateadd(mm ,- 10, getdate())) year,MONTH(dateadd(mm ,- 10, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 9, getdate()),
120
) sj,YEAR(dateadd(mm ,- 9, getdate())) year,MONTH(dateadd(mm ,- 9, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 8, getdate()),
120
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 12, getdate()),
120
) sj,YEAR(dateadd(mm ,- 12, getdate())) year,MONTH(dateadd(mm ,- 12, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 11, getdate()),
120
) sj,YEAR(dateadd(mm ,- 11, getdate())) year,MONTH(dateadd(mm ,- 11, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 10, getdate()),
120
) sj,YEAR(dateadd(mm ,- 10, getdate())) year,MONTH(dateadd(mm ,- 10, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 9, getdate()),
120
) sj,YEAR(dateadd(mm ,- 9, getdate())) year,MONTH(dateadd(mm ,- 9, getdate())) month
UNION ALL
SELECT
CONVERT (
VARCHAR (7),
dateadd(mm ,- 8, getdate()),
120