title: How to increment date by 1 for number of time in sql statement
body: <p>I am trying to increment date by one for some limited number of time.  I was able to increment the current date by 1:</p>
  
  <pre><code>Select *, DATEADD(d,1, GETDATE()) From MyTable;
  </code></pre>
  
  <p>But I want to increment the date for number of time in each row Like:</p>
  
  <pre><code>ID              Date
  1            2012-05-14
  2            2012-05-15
  3            2012-05-16
  </code></pre>
  
  <p>How can do this?</p>