Question : sql case update
Answered by : sore-serval-4muojgn14vow
UPDATE dbo.TestStudents
SET LASTNAME = CASE WHEN LASTNAME = 'AAA' THEN 'BBB' WHEN LASTNAME = 'CCC' THEN 'DDD' WHEN LASTNAME = 'EEE' THEN 'FFF' ELSE LASTNAME END
WHERE LASTNAME IN ('AAA', 'CCC', 'EEE')
Source : https://stackoverflow.com/questions/15766102/i-want-to-use-case-statement-to-update-some-records-in-sql-server-2005 | Last Update : Wed, 12 May 21