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 |
|
Vaishu
Posting Yak Master
178 Posts |
 Posted - 2008-06-02 : 14:35:18
|
| Hi I have a table(tblA) as followsCol1--------------col2---------col3-----col4London------------1131---------299------BarkingDidicot-----------3451---------429------DansdonBarking/ASton-----1131---------345------SingletonVander/ADon/cam---3907---------299------derby Null or Blank ---1131---------423------AddingtonExpecting the Data should display look like belowLondon------------1131---------299------BarkingDidicot-----------3451---------429------DansdonBarking/ASton-----1131---------345------SingletonVander/ADon/cam---3907---------299------derby But when user change the col2 value (1131) to 113999, this should be changed to all values where col2 is 1131. Please Help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-02 : 14:45:02
|
| Didnt get you. What's 113999? Is that value input by user? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-02 : 14:53:48
|
| Is this what you want?UPDATE tblASET col2= 113999WHERE Col2=1131 |
|
|
|
|
|
|
How to update values from the user input?