Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Answer
Stored Prodedure for inserting data from a XML file
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Abdus Sakur
19y
1.7k
1
Reply
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
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
Exporting Table Data in a text file
How to cancel deletion of a row in DataGrid?