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 - 2006-02-17 : 08:53:06
|
| Vlad writes "I need to insert multiple records from web page by calling Insert stored proc. All those record are related to the same Request ID in the Parent Table. All those records have different values exept Request ID. How to Insert all records with one call of stored proc. Right now we loop through records on the web page and calling proc as many time as many records we have. It works OK but may be there is more efficient method.Thank youVlad" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-02-17 : 08:56:59
|
| There are a number of links here that describe ways of doing this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=43400 |
 |
|
|
|
|
|
Multiple records insert from web page using vb.net.