create functions for encrypt and decrypt of password

Question

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 Shanu · Answer

Try this  Hope this will help you. declare @MYEncriptionm varbinary(200) select @MYEncriptionm = EncryptByPassPhrase('key' 'shanu' ) select @MYEncriptionm select convert(varchar(100)DecryptByPassPhrase('key' @MYEncriptionm )) http://sqlmag.com/t-sql/simple-string-encryption-and-decryption

Nanhe Siddique · Answer

then read this following link http://www.c-sharpcorner.com/UploadFile/97fc7a/database-table-encryption-using-symmetric-key-in-sql-server/ http://www.databasejournal.com/features/mssql/article.php/3922881/Column-Level-Encryption-in-SQL-Server.htm http://blogs.msdn.com/b/lcris/archive/2005/06/09/simple-demo-for-how-to-encrypt-and-decrypt-a-table-column-in-sql-server-2005.aspx it may help you

hadoop hadoop · Answer

Hello guys Please guide how can I make encryptiong and decryptiong fuctions in MS SQL. Thanks!

hadoop hadoop · Answer

Sorry to mention but I need sql functions for encryption and decryption not C# function.

Nanhe Siddique · Answer

read this link http://www.aspsnippets.com/Red/Articles/Encrypt-and-Decrypt-Username-or-Password-stored-in-database-in-ASPNet-using-C-and-VBNet.aspx it may help you