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 |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2008-12-21 : 06:23:59
|
| HelloI want to save multiple rows at a time.I have object array and serialized it to xml. Then i dont know how can i insert into db. Or is there anyway to save obj array at a time?Thanks in advance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-21 : 09:50:56
|
| You can use OPENXML to convert the XML into relational rows, but we'd need to see the XML and the structure of the tables you're trying to insert into. There are other XML methods you can also use, but we'd need more detail on how you're splitting the XML data. |
 |
|
|
|
|
|
how to insert multiple rows ?