title: how to write more than one insert statements in stored procedure with two table parameters
body: <p>I have two tables </p>
  
  <pre><code>Employee----&gt;Id(identity),FN,LN,Address
  
  EmpContact---&gt;Id(identity),Empid(Above table identity value),ContactType,ContactNumber
  </code></pre>
  
  <p>How to write two tables insert statements in single stored procedure. The second table "EmpContact" needs the resulted Identity ID from insertion in the first table "Employee"</p>