Solved

how to write data from xml file to database

Posted on 2009-05-11
4
279 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
  • 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Some sers suddenly getting error popup msg 28 89
T-SQL: Do I need CLUSTERED here? 13 44
SSRS Enable Remote Errors 4 26
Proper Case SQL Command 2 9
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

777 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