Solved

how to write data from xml file to database

Posted on 2009-05-11
4
280 Views
Last Modified: 2013-11-27
i want to write some data from xml file to database. but it is not working properly. Im using the opnexml() in the stored procedure
0
Comment
Question by:logicslab
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24352709
I have written very small yet useful article to load relational data into SQL Server. have a look.

http://www.sqlhub.com/2009/04/load-relational-xml-data-in-sql-server.html
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24352719
you can store XML data along with it TAG also, if you have XML datatype in any column. have a look few more useful articles.

http://msdn.microsoft.com/en-us/library/ms345117.aspx

http://www.sql-server-performance.com/articles/dev/xml_data_2005_p1.aspx
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 24353175
Hi logicslab,

Have a look at the following:
http://www.sqlservercurry.com/2008/09/how-to-import-xml-data-in-sql-server.html

Good Luck!

Gary
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24357186
>>i want to write some data from xml file to database. but it is not working properly. Im using the opnexml() in the stored procedure<<
Please post your Stored Procedure and indicate why "it is not working properly".
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Parsing this XML works but the other one doesn't 9 30
Trigger C# code inside the SQL Server 6 33
SQL Syntax 6 31
Related to SQL Query 5 21
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question