title: insert select statement with certain columns only
body: <p>i am trying to insert data to table1 from 2 columns from table2.</p>
  
  <p>table1 has 5 columns.c1,c2,c3,c4,c4</p>
  
  <p>what i am doing now is</p>
  
  <pre><code>insert into table1(c1,c2,c3,c4,c5)select t1,t2,getdate(),NULL,getdate() from table2
  </code></pre>
  
  <p>no error returns. Return result was no rows were affected.
  can anyone tell me how to insert 3 fix value for last 3 columns?</p>