如下包含了md5和shal加密用法
select 'admin' as username, sys.fn_VarBinToHexStr(hashbytes('MD5','admin')) as pw_md5, sys.fn_VarBinToHexStr(hashbytes('SHA1','admin')) as pw_shal
注解:
hashbytes()返回varbinary类型值;
sys.fn_VarBinToHexStr()是把varbinary转换成varchar;
select 'admin' as username, sys.fn_VarBinToHexStr(hashbytes('MD5','admin')) as pw_md5, sys.fn_VarBinToHexStr(hashbytes('SHA1','admin')) as pw_shal
注解:
hashbytes()返回varbinary类型值;
sys.fn_VarBinToHexStr()是把varbinary转换成varchar;