79084752

Date: 2024-10-14 05:05:47
Score: 1
Natty:
Report link
    UPDATE dbo.TestStudents
    SET LASTNAME = 
        CASE LASTNAME
             WHEN 'AAA' THEN 'BBB'
             WHEN 'CCC' THEN 'DDD'
             WHEN 'EEE' THEN 'FFF'
        END
     WHERE LASTNAME IN ('AAA', 'CCC', 'EEE');
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: ralph rapiz