Say I am having a table ZeroOneZero with following data
select * from ZeroOneZero
name Active
---------- ------
Prakriti 0
Aaliya 1
Falak 0
Snehal 1
(4 row(s) affected)
Now what I want is to convert 0 values in Active column to 1 and vice versa. It seems very easy to do, yes absolutely
it is, but you need make sure you don’t have to use where clause in Update statement else you will end up getting something
unexpected….
Let’s check out how to get done with this problem, the Case
clause is the solution:
update
ZeroOneZero
set Active =
(case when Active = 0 then 1
when Active = 1 then 0
end)
(4 row(s) affected)
/*Now lets fire select query to see
the result*/
select * from ZeroOneZero
name Active
---------- ------
Prakriti 1
Aaliya 0
Falak 1
Snehal 0
(4 row(s) affected)
Yes we are through.
Coding a Psyche Game
Post Reference: Vikram Aristocratic Elfin Share
