SQL單向加密函數

DECLARE @ClearPWD varchar(255)

DECLARE @EncryptedPWD varbinary(255)

SELECT @ClearPWD = 'test'

SELECT @EncryptedPWD = CONVERT(varbinary(255), pwdencrypt(@ClearPWD))

SELECT @EncryptedPWD

SELECT pwdcompare(@ClearPWD, @EncryptedPWD, 0)

SELECT pwdcompare('ErrorPassword', @EncryptedPWD, 0)