How
to save Password Encrypt form and show
password Decrypt form in Sql Server 2008
--first
create table logindetails in database test.....
use test
create table
logindetails (EmailId
nvarchar(50) primary key,Password nvarchar(50))
--Insert Encrypted Password in Sql Server:-
insert into
logindetails (EmailId,Password) values ('kush@cetpainfotech.com',encryptbypassphrase('passkey','kush1234'))
-- fetch data from
table without Decrypted form
select * from logindetails
-- Show data with Decrypted form
select
EmailId,CONVERT(varchar(max),Decryptbypassphrase('passkey',Password)) as Password from logindetails
This is great topic ! It's all the rage out here....
ReplyDelete