Password Encryption And Decryption In SQL SP

In this blog, I have explained the process of securing password using Encryption and Decryption in SQL Stored Procedure.

 

STEP 1

Open SQL Server and create database and table as you do normally.

STEP 2

In stored procedure, we have to declare the variable (Password) which should be Encrypted and Decrypted.

 

STEP 3

To encrypt the word used in password, write the query given below.

Declare @Encrypt varbinary(200)
Select @Encrypt = EncryptByPassPhrase('key', 'Jothish' )
Select @Encrypt as Encrypt

STEP 4

To decrypt the word used in password, write the query given below.

Select convert(varchar(100),DecryptByPassPhrase('key',@Encrypt )) as Decrypt

STEP 5

As a result, the password has been encrypted and decrypted in SQL SP. The below image shows the working of the code.

 

               

 

Hope, this blog will help you.