title: SQL SERVER table alias in stored proc
body: <p>Is there a way to give an alias to a table which will then be referenced within a store procedure.</p>
  
  <pre><code>Declare @target= (sometalbewithveryverylonganduglyname)
  Declare @source= (anothertablewithaveryuglyverylongverybadname)
  
  Select * from @target
  
  Insert into @target select from @source
  
  delete from @source
  </code></pre>
  
  <p>Reason being, the table source and target could change (if the tablename is changed then we just change in one location), and for better readability.</p>