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-15 : 12:50:57
|
| Mike writes "Hi, I want to be able to SELECT a number of records from a table with quite a complicated WHERE clause and update a field in these returned records at the same time without running a seperate UPDATE query with the same WHERE clause again. I assume this would double the processing time? Can this be achieved, or would it be more efficient to update the fields in the returned record set by using ADO? I'm really looking for the most efficient way in terms of speed in achieving this as it is an integral part of a scalable web application where the table in question could contains thousands of records. Any help would be much appreciated. TIA." |
|
|
|
|
|
selecting records and updating at same time