UPDATE
    TOTAL_SCORES AS TS
SET
    TOTAL_SCORE = SUB.SMSC
FROM(
    SELECT 
        STUDENT_CODE
        ,SUM(SCORE) SMSC
    FROM 
        SCORES
    GROUP BY
        STUDENT_CODE
    ) AS SUB
WHERE 
    TS.STUDENT_CODE=SUB.STUDENT_CODE