MSSQL UPDATE script to increment date values in a table?
<p>I'm looking for a way to take dates in a table and update them. Example:</p>

<pre><code>ID / DATE
2   2016-02-26 10:15:25.000
3   2016-05-27 09:27:13.000
...
...
9   2016-08-14 22:56:45.000
10  2016-09-05 16:32:24.000
11  2016-12-13 02:13:17.000
</code></pre>

<p>I'd like to just increment the dates for every date by a fixed # of days (eg. 1 day, 5 days, 10 days)</p>

<p>So, <code>2016-08-14 22:56:45.000</code> would be (10 days) <code>2016-08-24 22:56:45.000</code></p>

<p>Essentially what I'm hoping to do is update some 'sample date' to look 'current'. Thanks for any help.</p>