Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2013-05-29 : 15:55:05
|
| Hi All,I have created one upload in ASP.Net which upload XML file into SQL Table which is having XML data type. Now I have to read this data and move them into diffrent tables.Please suggest how to proceed |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-29 : 15:57:00
|
| You will have to shred the XML. SQL has several methods that can be used to shred XML data; how you write the query to shred it depends on the schema of the XML data. This article has some information: http://www.sqlservercentral.com/articles/XML/87685/ Also, MSDN documentation has several examples. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-30 : 01:32:02
|
| http://visakhm.blogspot.in/2012/10/shred-data-as-well-as-metadata-from-xml.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
XMl Upload