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 - 2001-02-22 : 09:06:53
|
Susan writes "I have an ASP script that updates several separate tables. (10!). The programmer who originally wrote it has is creating 10 separate calls to the SQL server and now it is timing out. Is the best solution to put all of the update procedure into ONE stored procedure on the db server thereby only making one trip to the server? How do you open up several different recordsets within a sp?
Thanks" |
|
|
|
|
|
Opening multiple RSets