MSSQL – UPDATE CASE WHEN

UPDATE tbl_persons SET
gender_description =
CASE
WHEN gender = '1' THEN 'male'
WHEN gender = '2' THEN 'female'
ELSE 'unknown'
END
This entry was posted on Tuesday, January 8th, 2019 at 9:59 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.