Update Date Columns with specific intervals sql • Nov 7, 2012 There are cases when you want to modify the entire date values and add a specific interval say add and Year, The easiest way to do that is update [Table] set ColumnName= DATEADD(YEAR,1,ColumnName) Naresh Jois Recommended for you Crashed Recover Jobs from a crashed SQL Server 11 years ago • 1 min read identity Nifty Little script to check identity columns 11 years ago • 1 min read