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 |
|
hem
Starting Member
1 Post |
 Posted - 2007-08-28 : 16:47:00
|
| Hi I m new to the forum and to Server 2005 I have to transfer data from large XML files to Server 2005.I need to have the value from each text node as a row.so here is a sample XML <?xml ......><A> <B time = 1> <C> Value = something </C> <D> Value = something</D> ...... </B></A> <A> <B time = 2> <C> Value = something </C> <D> Value = something</D> ...... </B></A> What i want to do is have columns in Server 2005 table named B,C and D and store each time as a row in those coloumns . i want tp store just the value not the whole XML. I am sure this is really basic .Can some one give me some direction as to how to do this Thanks ~ Hem |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 18:36:50
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspxyou can use nodes() function of xml datatype to convert nodes to rows_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
data from XML to server 2005