title: Insert into table with Identity and foreign key columns
body: <p>I was trying to insert values from one table to another from two different databases.</p>
  
  <p>My issue is I have two tables with a relation and the first table is having an identity column also.</p>
  
  <p>eg table first(id, Name) - table second(id, address)</p>
  
  <p>So now both the table exist with values in a db and i am trying to copy values from this db to another db.</p>
  
  <p>So when I insert values from first db to second db the the first table will insert values for the Id column by itself so now I have to link that id to the second table. </p>
  
  <p>How can I do that?</p>
  
  <p><em>UPDATE</em> using MSSQL server 2000</p>