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 |
|
sqllover
Constraint Violating Yak Guru
338 Posts |
 Posted - 2008-03-21 : 08:47:19
|
| hi, i have column salary in my table emp. my column values are as follows: salary: 20000 30000 40000 50000so i need to update this column values in a single update statement.so my values as follows:salary:10000100001000010000so please give me example query to update this please |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-03-21 : 08:49:55
|
| UPDATE empSET salary = 10000 will change every single salary in emp to 10000Jim |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-21 : 10:50:09
|
Sounds like lots of people are going to be surprised on payday.  CODO ERGO SUM |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-03-21 : 10:55:30
|
| Well in that caseUPDATE empSET salary = 100000Who'll notice just one 0?! |
|
|
|
|
|
|
how to update all the values of column