■ PWDENCRYPT 함수 : 패스워드 암호화 하기

----------------------------------------------------------------------------------------------------

DECLARE @Password NVARCHAR(100);

 

SET @Password = 'qweasdzxc';

 

DECLARE @EncryptedPassword VARBINARY(255);

 

SET @EncryptedPassword = PWDENCRYPT(@Password);

 

SELECT @EncryptedPassword AS [Encrypted Password];

 

실행 결과

 

Encrypted Password

------------------------------------------------------

0x010046BA0E6613104FAAEAD887DF8188597B3F4D3CA9211AF771

----------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요