How to encrypt and decrypt data in SQL Server
---Script
declare @hashkey varchar(100)='ssunitech'
select BusinessEntityID,
LoginID,ENCRYPTBYPASSPHRASE(@hashkey,cast(LoginID as varchar(100))) LoginID_H,
ENCRYPTBYPASSPHRASE(@hashkey,'ssunitech@123') as password
Into LoginDetails
from [HumanResources].[Employee]
select *,cast(deCRYPTBYPASSPHRASE('ssunitech',LoginID_H) as varchar(1000)) ,
cast(deCRYPTBYPASSPHRASE('ssunitech',password) as varchar(1000))
from LoginDetails
Find Us On KZitem- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For SQL Quiz-
• sql server : Interview...
Find Us On FaceBook-
/ ss-unitech-18770538867...
Негізгі бет HOW TO ENCRYPT AND DECREYPT PASSWORD BY USING ENCRYPTBYPASSPHRASE AND DECRYPTBYPASSPHRASE IN MSSQL
Пікірлер: 7