just posting that neither of the options given is the best way to calculate the age, as it's not the fastest way

doing YEAR(getdate() - Birthdate - 1) - 1900 is...