Cryptographic Functions (Transact-SQL)

SQL Server TechCenter

Troubleshooting

Printer Friendly Version

Send

TechNet Library

TechNet Library

Products and Technologies

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

Functions (Transact-SQL)

Cryptographic Functions (Transact-S...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All/Expand All

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 2009)

Cryptographic Functions (Transact-SQL)

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

See Also

Reference

Functions (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
Security Catalog Views (Transact-SQL)

Other Resources

Encryption Hierarchy
Permissions Hierarchy (Database Engine)

Help and Information

Getting SQL Server 2008 Assistance

Tags

What's this?

: Add a tag

Community Content

What is Community Content?

Add new content

Annotations

Processing

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement