0
Answer

Stored Prodedure for inserting data from a XML file

Abdus Sakur

Abdus Sakur

19y
1.7k
1
Suppose this is a xml file:
<HMS xmlns="http://tempuri.org/HMS.xsd">
  <Department> /// table name
    <DepartmentId>DP0001</DepartmentId> /// <fieldname>value</fieldname>
    <DepartmentName>Eye</DepartmentName>
    <DepartmentStatus>0</DepartmentStatus>
  </Department>
  <Department>
    <DepartmentId>DP0002</DepartmentId>
    <DepartmentName>Nose</DepartmentName>
    <DepartmentStatus>1</DepartmentStatus>
  </Department>
</HMS>
-----------------------------------------------

I want a stored procedure to insert the data.

Thanks
ZAMI