United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Built-in Functions (Transact-SQL)

Cryptographic Functions (Transact-SQL)

ASYMKEY_ID (Transact-SQL)

ASYMKEYPROPERTY (Transact-SQL)

CERTPROPERTY (Transact-SQL)

CERT_ID (Transact-SQL)

CRYPT_GEN_RANDOM (Transact-SQL)

DECRYPTBYASYMKEY (Transact-SQL)

DECRYPTBYCERT (Transact-SQL)

DECRYPTBYKEY (Transact-SQL)

DECRYPTBYKEYAUTOASYMKEY (Transact-SQL)

DECRYPTBYKEYAUTOCERT (Transact-SQL)

DECRYPTBYPASSPHRASE (Transact-SQL)

ENCRYPTBYASYMKEY (Transact-SQL)

ENCRYPTBYCERT (Transact-SQL)

ENCRYPTBYKEY (Transact-SQL)

ENCRYPTBYPASSPHRASE (Transact-SQL)

HASHBYTES (Transact-SQL)

IS_OBJECTSIGNED (Transact-SQL)

Key_GUID (Transact-SQL)

Key_ID (Transact-SQL)

KEY_NAME (Transact-SQL)

SIGNBYASYMKEY (Transact-SQL)

SIGNBYCERT (Transact-SQL)

SYMKEYPROPERTY (Transact-SQL)

VERIFYSIGNEDBYCERT (Transact-SQL)

VERIFYSIGNEDBYASYMKEY (Transact-SQL)

Minimize

1 out of 1 rated this helpful - Rate this topic

Cryptographic Functions (Transact-SQL)

SQL Server 2012

The following functions support encryption, decryption, digital signing, and the validation of digital signatures.

Symmetric Encryption and Decryption

EncryptByKey	DecryptByKey
EncryptByPassPhrase	DecryptByPassPhrase
Key_ID	Key_GUID

Asymmetric Encryption and Decryption

EncryptByAsmKey	DecryptByAsmKey
EncryptByCert	DecryptByCert
Cert_ID	AsymKey_ID
CertProperty

Signing and Signature Verification

SignByAsymKey	VerifySignedByAsmKey
SignByCert	VerifySignedByCert

Symmetric Decryption with Automatic Key Handling

DecryptByKeyAutoCert

Encryption Hashing

Copying Certificates

CERTENCODED (Transact-SQL)
CERTPRIVATEKEY (Transact-SQL)

Reference

Built-in Functions (Transact-SQL)

CREATE CERTIFICATE (Transact-SQL)

CREATE SYMMETRIC KEY (Transact-SQL)

CREATE ASYMMETRIC KEY (Transact-SQL)

Security Catalog Views (Transact-SQL)

Concepts

Encryption Hierarchy

Permissions Hierarchy (Database Engine)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.