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-07-19 : 21:10:30
|
| Jim writes "How do you force Update to one record or a specific number of records if the WHERE clause in the Update statement returns multiple records? All the records in the collection have the same criteria. For example, Update HISTORY set "ordnum = '" & 111111 & "' where ordnum = '" & "" & "'" could return 10 records where the ordnum is blank. However, I want to update the first record only." |
|
|
|
|
|
Update one record from a quary returning multiple records