Do you mean how you change the password. If that's the question, as long as you have necessary privileges, you can use the
ALTER LOGIN[
^] statement to change the password. For example:
ALTER LOGIN SomeLoginName WITH PASSWORD = 'NewPasswordToBeSet';
Note: Never directly concatenate values to your SQL statement. That leaves you open to SQL injections, data type conversion problems and so on. Instead use
SqlParameter[
^].