Vishal Jadav
How to encrypt / decrypt password in SQL server 2012?
By Vishal Jadav in SQL Server on Aug 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 Job Functions