How can I write functions for password encryption and decryption using EncryptByPassphrase and DecryptByPassphrase and use these functions while storing and retrieving password from user table.
the EncryptByPassphrase takes two parameters, a @passphrase and the @cleartext. what is this @passphrase?
Syed ShanuPosted May 21, 2015, 12:17 AM
select @MYEncriptionm = EncryptByPassPhrase('key', 'shanu' )
select @MYEncriptionm
select convert(varchar(100),DecryptByPassPhrase('key', @MYEncriptionm ))
Nanhe SiddiquePosted May 21, 2015, 12:03 AM
hadoop hadoopPosted May 20, 2015, 11:51 PM
hadoop hadoopPosted May 19, 2015, 9:35 AM
Nanhe SiddiquePosted May 19, 2015, 8:14 AM