Combine multiple xml tags in sqlserver : I have some problem with xml in sqlserver. I can't compine multiple xml tags in one variable sql
I need combine first_name, last_name and father_name
 

    <BODY><type>insert</type><table_name>Customer</table_name>
     <First_name>Мирмухаммедов</First_name>
     <Last_name>Мирмухаммедов</Last_name>
     <Father_name>Rahmonovich</Father_name>
     <Birth_date>12.12.2018</Birth_date>
     <Country>Dushanbe</Country>
     </BODY>