DECLARE @DT_NOW AS DATETIME
SET @DT_NOW = GETDATE()

SELECT YEAR(@DT_NOW) - 1 AS 'old_year'

--ca manque de commentaires
>>>>>>> 544ba62e15d71cf87c01c057cb872064dcfd9a65