January 12, 2015 by pramod thakur in Interview Question, SQL
update NewTable set status= case status when 1 then 0 when 0 then 1 end