title: Inserting rows into table with only one column left and with out using column names
body: <p>I have two identical tables A and B. Identical in the sense they both have same type of columns having the same name and data type.</p>
  
  <p>A is having 100 columns and B is having 101 columns.</p>
  
  <p>Only difference between them is B is having one extra column.</p>
  
  <p>Now I am tryuing to insert the columns from A to B .</p>
  
  <p>If both tables have same no of columns I can use the following insert statement.</p>
  
  <pre><code> insert into B 
  select * from A;
  </code></pre>
  
  <p>since both the tables having different number of columns i have to write all the columns names in the insert statements.</p>
  
  <pre><code>insert into B (col1,........col100)
  select col1....col100 from A;
  </code></pre>
  
  <p>Now My question is .. is there any way we can write the statement in a simpler way like below so that time and no of lines in the code can be saved.</p>
  
  <pre><code>insert into B (exclude column 101)
      select * from A;
  </code></pre>