title: renaming a temporary table into a physical one
body: <p>Can I do something like this?</p>
  
  <pre><code>create table #tbl_tmp (col1 int)
  
  insert into #tbl_tmp select 3
  
  exec sp_rename '#tbl_tmp','tbl_new'
  </code></pre>