Function to calculate a persons Age in T-SQL

SQL Server includes a datediff function that you can use to calculate the number of days, months, years etc between two dates, but this function can’t be used alone to calculate a persons age. If you return the number of years from the datediff function, your Age calculation could be 1 year out. ................
................