title: Update query in sql server
body: <p>I have two tables   <strong>table1</strong> with fields <strong>f1</strong>, <strong>f2</strong></p>
  
  <p>and</p>
  
  <p><strong>table2</strong> with fields <strong>id,f1,f2</strong>, where id is incremental field</p>
  
  <p>I need to take the values from  <strong>table1</strong> and need to insert into <strong>table2</strong></p>
  
  <p>Can anyone give the query for that,in sql server</p>