Skip to content

Instantly share code, notes, and snippets.

@jadiagaurang

jadiagaurang/ENCRYPT-DECRYPT.sql

Created September 13, 2020 02:47
Show Gist options
  • Save jadiagaurang/824584bfb591561f99d61e17222783a5 to your computer and use it in GitHub Desktop.
Save jadiagaurang/824584bfb591561f99d61e17222783a5 to your computer and use it in GitHub Desktop.
Download ZIP
ENCRYPT-DECRYPT Varbinary
Raw
ENCRYPT-DECRYPT.sql
DECLARE @CC VARBINARY(1000);
SET @CC = ENCRYPTBYPASSPHRASE('secretcode','1212704331100');
SELECT CONVERT(VARCHAR(100), DECRYPTBYPASSPHRASE('secretcode', @CC));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment