Hi everybody,
i am facing problem in encoding password to store in sql database for login table.so if you know pls tell me the solution.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sukesh MarlaPosted Sep 6, 2012, 6:52 AM
And better if you encode password in .net and then pass it to sql, For better protection.
Check this is corerct answer if it helped.
Rajeev KumarPosted Jul 10, 2023, 9:23 AM
Declare @Encrypt varbinary(200)
Select @Encrypt = EncryptByPassPhrase('key', 'Jothish' )
Select @Encrypt as Encrypt
Select convert(varchar(100),DecryptByPassPhrase('key',@Encrypt )) as Decrypt
Satyapriya NayakPosted Sep 6, 2012, 7:12 AM
Please refer the below links
http://webcheatsheet.com/asp/md5_encrypt_passwords.php
http://www.aspdotnet-suresh.com/2010/12/introduction-here-i-will-explain-how-to_28.html
Thanks
If this post helps you mark it as answer