1、Oracle11G数据库修改用户密码SQL语句
update cp_user sm set sm.user_password= 'U_U++--V'||LOWER( RAWTOHEX( UTL_RAW.CAST_TO_RAW( sys.dbms_obfuscation_toolkit.md5(input_string => sm.cuserid||'1'/**要设置的密码*/) ) ) ) where sm.user_code ='1234';
2、SQLServer数据库修改用户密码SQL语句
update sm_user set user_password =
'U_U++--V'+LOWER(RIGHT(sys.fn_varbintohexstr(HASHBYTES('MD5',cuserid+'1')),32))
where user_code ='1234';