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

How to encrypt and decrypt data in SQL Server
---Script
declare @hashkey varchar(100)='ssunitech'

select BusinessEntityID,
Into LoginDetails
from [HumanResources].[Employee]

select *,cast(deCRYPTBYPASSPHRASE('ssunitech',LoginID_H) as varchar(1000)) ,
cast(deCRYPTBYPASSPHRASE('ssunitech',password) as varchar(1000))
from LoginDetails

For SQL Quiz-

Find Us On FaceBook-

[dhanarajumattaparthi]

Nice...thanks for sharing knowledge on this

[sidharthabehera]

How to use Encrypt password in stored procedure please make a video

[mohimakhter]

That's Great, But how can we create the private key of users

[landchennai]

How it differ from dynamic data masking?