yoursyun
3DES 암호화 복호화 본문
OPEN MASTER KEY DECRYPTION BY PASSWORD = '암호'
OPEN SYMMETRIC KEY PasswordFieldSymmetricKey DECRYPTION BY CERTIFICATE TiwazPasswordFieldCertificate WITH PASSWORD = '암호'
DECLARE @ENC VARBINARY(256) = EncryptByKey(Key_GUID('PasswordFieldSymmetricKey'), 'AAAAA')
SELECT @ENC
SELECT CONVERT(varchar, DecryptByKey(@ENC))
반응형