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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-29 : 11:43:03
|
| Arvind writes "Hi,I have created one table called XMLtransfer(which is directly comming from oracle),this table have one field called info(text(16). Info field have complete XML data. Now I would like to split info XML data into new SQL table.examplenew table XMLanalysis and field areIDnameagecityname,age,city is avaiable on info field XML data.IS possiable with MS sql 2000, if yes then how please give me detailed suggestionRegardsArvind" |
|
|
|
|
|
Spliting XML into multiple Table field