Abdus Sakur

Abdus Sakur

  • NA
  • 3
  • 0

Stored Prodedure for inserting data from a XML file

Sep 24 2005 12:57 AM
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