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 |
|
lakon15
Starting Member
12 Posts |
 Posted - 2008-01-03 : 23:14:27
|
| Dear All,I'm new handle XML file, I have a question how to create procedure insert XML data into SQL table, let say we have table with schema like this create table testXML(col1 real, col2 real, col3 real)I want to insert XML data<firstdata> <data>499,498.99,1.25</data> <data>500.01,500,1.9</data> <data>501.03,501.02,2.92</data> </firstdata>the result we need iscol1 col2 col3499 498.99 1.25 500.01 500 1.9501.03 501.02 2.92thank's beforeRegardsWahyu Tri |
|
|
|
|
|
Insert XML data into SQL table