Decrypts data with the private key of a certificate.
Is the ID of a certificate in the database. int.
Is a string of data that has been encrypted with the public key of the certificate.
Is a variable of type varbinary that contains data that has been encrypted with the certificate.
Is the password that was used to encrypt the private key of the certificate. Must be Unicode.
Is a variable of type nchar or nvarchar that contains the password that was used to encrypt the private key of the certificate. Must be Unicode.
The following example selects rows from
[AdventureWorks].[ProtectedData04] that are marked as
data encrypted by certificate JanainaCert02. The example decrypts the ciphertext with the private key of certificate
JanainaCert02, which it first decrypts with the password of the certificate,
pGFD4bb925DGvbd2439587y. The decrypted data is converted from varbinary to nvarchar.
SELECT convert(nvarchar(max), DecryptByCert(Cert_Id('JanainaCert02'), ProtectedData, N'pGFD4bb925DGvbd2439587y')) FROM [AdventureWorks].[ProtectedData04] WHERE Description = N'data encrypted by certificate '' JanainaCert02'''; GO