Wednesday, February 3, 2016

ENCRYPT / DECRYPT SQL SERVER



DECLARE @x VARBINARY(8000) = ENCRYPTBYPASSPHRASE('MKSABC','2424');
-- SELECT AFTER DECRUPT
SELECT @x , CONVERT(VARCHAR(32), DECRYPTBYPASSPHRASE('MKSABC', @x)) 'AFTER DECRUPT';

No comments: