select query for Encrypted data from another database
select query for Encrypted data from another database
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abdu RafeeqPosted Mar 24, 2011, 11:44 PM
go
OPEN SYMMETRIC KEY JimsKey DECRYPTION BY CERTIFICATE JimsCertselect
CONVERT
(nVARCHAR(100),DECRYPTBYKEY(ENCRYPTBYKEY(KEY_GUID('JimsKey'),A1.Name))) AS Name,A1
.Code as Codefrom
Temp..A1this will return NUll Value
Suthish NairPosted Mar 24, 2011, 10:55 AM