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 |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2006-09-09 : 06:19:25
|
| I have one table NewTab with column Col1,Col2 and col3 with following dataCol1 Col2 Col31 2 Null 1 3 Null 1 4 Null1 5 Null7 10 Null7 9 Null7 8 Null7 7 NullI want to interchange the data between Col2 to Col3 .The resulte should beCol1 Col2 Col31 NULL 2 1 Null 3 1 Null 41 Null 57 Null 107 Null 97 Null 87 Null 7Please tell me how I can interchange this data (which method)SQLTeam |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-09 : 06:23:35
|
| Update YourTable Set Col2 = Col3, Col3= Col2Chirag |
 |
|
|
|
|
|
How to interchange data between column