• Is most simple:
       DECLARE @Birthday date = '1994/12/10'

        SELECT (CAST(CONVERT(VARCHAR(8), GETDATE(), 112) AS INT) - CAST(CONVERT(VARCHAR(8), @Birthday, 112) AS INT)) / 10000 AS Age