How to change male to female and female to male in Sql server :-

UPDATE employee SET
gender = CASE gender WHEN 'male' THEN 'female' WHEN 'female' THEN 'male'
ELSE gender
END

results matching ""

    No results matching ""