Caluculate sum of digits in sql

Question

Hi, i am new to sql server , i find a requirement some where in the google, please help me.

 

Q1:12345 (passed as a parameter in stored procedure)

Result: 15

 

How to acheive it?

 

Q2: 'ABCDE'

Find sum of ascii values of each charcter in the string.