title: Copy rows from the same table and update the ID column
body: <p>I have the following table</p>
  
  <p><img src="https://i.stack.imgur.com/k6GLk.jpg" alt="alt text"></p>
  
  <p>I have inserted Product B to it and it gives me an ID of 15</p>
  
  <p>Then I have the definition table which is as follows.</p>
  
  <p><img src="https://i.stack.imgur.com/7e7lL.jpg" alt="alt text"></p>
  
  <p>I want to select the ProductDefinition rows where ProdID = 14 and replicate the same and insert it for ProdID = 15 like the following</p>
  
  <p><img src="https://i.stack.imgur.com/UhTOB.jpg" alt="alt text"></p>
  
  <p>How to achieve this using SQL code?</p>