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 |
|
MikeB
Constraint Violating Yak Guru
387 Posts |
 Posted - 2003-10-24 : 10:49:03
|
| Is it possible to select the records updated using the UPDATE method:eg:SELECT * (UPDATE tbl SET field = 1 WHERE (field IN (SELECT TOP 1 FROM tbl WHERE field = something)))I am using Access 97Mike B |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-10-24 : 10:58:52
|
| why are you doing this?You could SELECT them first using the criteria for the update, then do UPDATE. |
 |
|
|
MikeB
Constraint Violating Yak Guru
387 Posts |
Posted - 2003-10-24 : 11:10:20
|
| Well, I was thinking that using UPDATE is faster then updating each record at a time so.... :)Mike B |
|
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-10-24 : 13:13:10
|
| Updating a set is almost always the way to go so good thinking on that but......the SELECT * thing was what I wanted to know why for... |
|
|
|
|
|
|
SELECT the recordset updated?