ICODEBROKER

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

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

DECLARE @Password NVARCHAR(100);

SET @Password = 'qweasdzxc';

DECLARE @EncryptedPassword VARBINARY(255);

SET @EncryptedPassword = PWDENCRYPT(@Password);

SELECT @EncryptedPassword AS [Encrypted Password];

/*

Encrypted Password

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

0x010046BA0E6613104FAAEAD887DF8188597B3F4D3CA9211AF771

*/

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