Sum of different values on the same row in a table
select *, Score1 + Score2 + ... + Score50 as TotalScore
from table


You can fill in the rest of the scores :-)

By the way, you really should normalise this table. It will make your life much easier.