title: Append SQL table name with today's date
body: <p>I understand that I can change a sql table using the follow sp:</p>
  
  <pre><code>EXEC sp_rename 'customers', 'custs'
  </code></pre>
  
  <p>How would I go about appending this so that the new table has today's date as a suffix?</p>
  
  <p>I've attempt variations on the below theme with little success!!</p>
  
  <pre><code>EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))'
  </code></pre>
  
  <p>Any help greatly appreciated.</p>