I want to add 1 year to a datetime-type column in every single row in a ... There is in fact a DATEADD statement in T-SQL, you can find it here
stackoverflow.com