daily pastebin goal
16%
SHARE
TWEET

Untitled

a guest Feb 20th, 2019 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. OPEN SYMMETRIC KEY NameOfSymmetricKey
  2.          DECRYPTION BY CERTIFICATE NameOfCertificate;
  3.  
  4.          Select EncryptDOB,  ISNULL(CONVERT(VARCHAR    (MAX),DecryptByKeyAutoCert    (cert_ID('NameOfCertificate'), NULL,     EncryptDOB)),'1900-01-01') As 'DateOfBirth'
  5.   from TableName
  6.  
  7.   CLOSE SYMMETRIC KEY NameOfSymmetricKey;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top