Wednesday, 4 April 2018

Data Encryption And Decryption in sql server using ByPassPhrase SQL Funtion

//////////////


declare @Encrypt varbinary(200)
select @Encrypt = EncryptByPassPhrase('key', 'abc' )
select @Encrypt

select convert(varchar(100),DecryptByPassPhrase('key', @Encrypt ))

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...