title: MSSQL insert rows into relational tables.
body: <p>I have two tables. <code>Person</code> and <code>Phones</code>. Many phones numbers could be associated with one person by foreign key. If I want to add a phone number and map it to particular person, how my SQL should look like? </p>
  
  <p>In my understanding:</p>
  
  <ol>
  <li><p>SQL statement should be transact, therefore first I have to insert person into <code>Person</code> table and after insert phone number in <code>Phones</code> and map it with just inserted row in <code>Person</code> table. </p></li>
  <li><p>What if row is already exist in one of another table? How should I handle it? </p></li>
  </ol>
  
  <p>I am Looking for a clean and simple solution or sql example. </p>
  
  <p>Note: I don't have access for creating stored procedures. </p>