HOW TO ENCRYPT AND DECREYPT PASSWORD BY USING ENCRYPTBYPASSPHRASE AND DECRYPTBYPASSPHRASE IN MSSQL

[@gautamkarkera5246]

Continue making contentful videos bro

[@NETTutorialsEasyWayToLearn]

i will

[@suryakanttakke3086]

good content video

[@NETTutorialsEasyWayToLearn]

I Will Make Such video......more

[@shreyaskarkera2329]

Nice dude..

[@NETTutorialsEasyWayToLearn]

Thanks

[@swapniltakke6417]

Good

[@NETTutorialsEasyWayToLearn]

thanks

[@zerosandones7547]

we can always replace the 8 with any value (string or number) right?

[@anuanitha1159]

Is this possible to decrypt the password without encrypted in mssql that means encryption was done by using java(MD5) algorithm

[@srinivast6746]

Thank you brother!!

[@lilianrgg]

thanks

[@josueromero4477]

Gracias bro

[@karankadam160]

Its not work in MS SQL 2017

[@wishbone6503]

I didn't get the code line of decrypting

[@NETTutorialsEasyWayToLearn]

Hey Rehana Akter,Thanks For Asking Me Dout,Here Is The Solution Below
Step 1 :Create database
Create database Protection
Step 2:Create table
Here In This step We Will Create table.
Here In This Step We Required Four Column With Name cid ,ename ,elocation and esalary using Parameter bigint,varchar and float.
create table Scan
(
sids bigint,
sname varchar(50),
spassword varchar(50),
sPrice float
);
Step 3 :Create Insert Trigger Functionality
Here In This Step We Will Insert Data Using Insert Command.
Data Will Be Added Manually Using Insert Command.
Here We Will Encrypt Data Using EncryptByPassPhrase Functionality.
Insert Into Scan (sids,sname,spassword,sPrice) values (1,'VIRAJ',EncryptByPassPhrase('Kayomacpro','ABC'),11000.2)
select *from Scan
Step 4 :Create Select Trigger Functionality
Here In This Step We Will View Data Using Select Command.
Data Will View Data Using Select Command.
Here We Will Decrypt Data Using DECRYPTBYPASSPHRASE Functionality.
select sids,sname,CONVERT(varchar(50),DECRYPTBYPASSPHRASE('Kayomacpro',spassword))as DecryptedPassword,sPrice from Scan
If you observe above query in EncryptByPassPhrase and DecryptByPassphrase I am using same string name 'Kayomacpro' to generate key for encryption and decryption otherwise it will not convert the string correctly.
You Can also Use
select sids,sname,CONVERT(nvarchar(max),DECRYPTBYPASSPHRASE('Kayomacpro',spassword))as DecryptedPassword,sPrice from Scan