消息关闭
    暂无新消息!

SQL Server中MD5加密

问题作者 : 黑眼猪2017-07-02发布
对出生日期加密后作为登录密码存入数据库

UPPER(SUBSTRING(sys.fn_sqlvarbasetostr(HASHBYTES('MD5',convert(varchar,borndate,112))),3,32))

1个回答

︿ 0
      SELECT   UPPER(SUBSTRING(sys.fn_sqlvarbasetostr(HASHBYTES('MD5',
                                                              CONVERT(VARCHAR, GETDATE(), 112))),
                                3, 32));
                          
--E5C4D3160124FC029340FB5012FFC682