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

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...