22,302
社区成员




DECLARE @Password NVARCHAR(100);
DECLARE @epwd NVARCHAR(500);
SET @Password = 'aaaaaa';
SET @epwd = CONVERT(VARCHAR(500),HashBytes('MD5',@Password),2);
SELECT @Password;
SELECT @epwd;
SELECT CONVERT(VARCHAR(500),HashBytes('MD5','aaaaaa'),2);
SELECT CONVERT(VARCHAR(500),HashBytes('MD5',@Password),2);
DECLARE @Password NVARCHAR(100);
SET @Password = 'aaaaaa';
SELECT
HashBytes('MD5', 'aaaaaa') AS [varcharMD5]
,HashBytes('MD5', N'aaaaaa') AS [nvarcharMD5]
,HashBytes('MD5', @Password) AS [nvarcharParaMD5]