database/mssql
3DES 암호화 복호화
yoursyun
2013. 3. 12. 11:50
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))
반응형