Database/MS-Sql Lecture33 pwdEncrypt 암호화 암호화 update users set LoginPwd=pwdencrypt('passwd12') where id=3 DECLARE @ClearPIN varchar(255) DECLARE @EncryptedPIN2 varchar(255) DECLARE @EncryptedPIN varbinary(255) SELECT @ClearPIN = 'passwd12' SELECT @EncryptedPIN2 = LoginPwd from users where id=3 SELECT @EncryptedPIN = CONVERT(varbinary(255), @EncryptedPIN2) SELECT pwdcompare(@ClearPIN, @EncryptedPIN, 0) 암호가 맞으면 1을 리턴 틀리면 0 리턴 2008. 8. 22. 이전 1 ··· 6 7 8 9 다음