title: select into a table with different column names
body: <p>In SQL, <code>Select into ...</code> copies rows into a different (backup) table. Is this possible if the backup table has different structure (or different column names)? If not, what is the best way to achieve this?</p>
  
  <p>Here is what I want to do: <code>TableA</code> has columns <code>a1,a2,a3</code>. I want to copy some rows from this table to another table <code>TableB</code> which has column <code>b1,b2,b3,b4</code>. Content of <code>a1</code> to go into <code>b1</code>, <code>a2</code> to <code>b2</code> etc.</p>