Person's Age in Years

This simple script will reveal (your) age in Years:

SELECT
@DateOfBirth = '6/24/1973'
, @Today = GETDATE()

SELECT
((((YEAR(@Today) * 365) + DATEPART(dy, @Today))
- ((YEAR(@DateOfBirth) * 365) + DATEPART(dy, @DateOfBirth)))
/ 365) AS AgeInYears