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 - 2004-12-07 : 08:34:14
|
| Tony Ozo writes "I would like to update current records in my table with records totaling 200. What would be the right syntax for the update to overwrite the existing records instead of appending to it. Thanks for your help." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-07 : 09:12:52
|
?????? i have no idea what are you asking....update MyTableset column1 = 200Go with the flow & have fun! Else fight the flow  |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-07 : 20:54:33
|
| i think he wants to update the 200 records.like what spirit said,update tablenameset field1=value1where 'your criteria here'--------------------keeping it simple... |
|
|
|
|
|
|
Updatign records