How can decrypt column in SQL SP

Bineeshcp Viswanath

7y1.7k

Dear All,

I have encrypted a table column and I want to display data decrypt data.

I have used below query to encrypt data. I need your help to how I can display data as it is in real.

And then the result is coming in my stored procedure is like this:-

and the output is :-

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Please find below link which will help you,

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-2017
+1
Bineeshcp Viswanath7y ago
I have done the below query and I can able to decrypt the data.
OPEN SYMMETRIC KEY symKeyPassport
DECRYPTION BY CERTIFICATE PassportNoCert;
SELECT CONVERT(nvarchar, DecryptByKey(PassportNo_encrypt)) AS Passport FROM tblCustomer

CLOSE SYMMETRIC KEY symKeyPassport;
+2
Vivek Kumar7y ago
Hi,
Please find below links for your reference.

https://www.c-sharpcorner.com/blogs/password-encryption-and-decryption-in-sql-sp

https://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/

https://www.dotnetheaven.com/article/encrypt-and-decrypt-text-in-sql-server-2008
0
Sanwar Ranwa7y ago
Download and install this you will get a tool

Open its first connect to your database server
Select the database >procedure and right click on it and click on Decrypt option
+1
Bineeshcp Viswanath7y ago
hello Sanwar,

I could not find the decryption part in the application after downloaded. kindly explain how I can decrypt the data
+1
Sanwar Ranwa7y ago
Hello

Please check these Links using this link you can decrypt sp

https://www.devart.com/dbforge/sql/sqldecryptor/
0