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-09-03 : 09:18:10
|
| RR writes "Is there any way to update multiple rows on a sql table when the number of rows that require updating can be variable? I need to pass in a set of input; 2 of the columns would be constant for all rows and 2 would be variable. In what format would it be best to pass the data through mqsi? Is there a looping function for this update or do I have to call the table as many times as I have rows to update? And, is the a subquery format for selecting rows after an update without writing 2 queries?" |
|
|
|
|
|
Updating multiple rows using VB/COM objects