Posts Tagged: case statement in update command in sql server

Toggle in sql server

update NewTable set status= case status when 1 then 0 when 0 then 1 end