Interviews - C# Corner

Vishal Jadav
How to encrypt / decrypt password in SQL server 2012?
By Vishal Jadav in SQL Server onAug 04 2016
  • Vishal Jadav
    Aug, 2016 4

    There are many methods in Sql server 2012 which allows you to encrypt password easily. ENCRYPTBYPASSPHRASE(YOURKEYPHRASE,PASSWORD)will give you varbinary result. To Get the actual result you need to convert using convert(varchar(50),DECRYPTBYPASSPHRASE(YOURKEYPHRASE,ENCRYPTED_VALUE)).

    • 0

Most Popular Companies

Most Popular Job Functions