title: How to loop and parse xml parameter in sql server stored procedure
body: <p>I want to write a stored procedure that accept an XML parameter, parsing it's elements and inserting them in a table. This is my XML:</p>
  
  <p><img src="https://i.stack.imgur.com/8UlIV.jpg" alt="My XML"></p>
  
  <p>I want to loop in that parameter(such as a foreach in C#), retrieving each person, then parsing it's data(ID,NAME,LASTNAME) inserting them in a table that has 3 fields.</p>
  
  <p>How can do that?</p>