select query for Encrypted data from another database

Question

Abdu Rafeeq · Answer

i set readable format but it possible in same database How it read from another database? go OPEN SYMMETRIC KEY JimsKey DECRYPTION BY CERTIFICATE JimsCert select CONVERT ( nVARCHAR ( 100 ) DECRYPTBYKEY ( ENCRYPTBYKEY ( KEY_GUID ( 'JimsKey' ) A1 . Name ))) AS Name  A1 . Code as Code from Temp .. A1 this will return NUll Value

Suthish Nair · Answer

You need to convert the data into readable format explain the thread with more information.