title: how to insert data from one table to another table(database)
body: <p>I have  two databases (<code>test1</code> and <code>test2</code>) on the same server, which have the same tables (<code>Employee</code>) with the same scheme. <code>Employee</code> holds around 1.500 rows.
  Now I want to copy the value of column <code>EmpDepID</code> for each PK.</p>
  
  <p>How can I achieve this?</p>