Cryptographic Functions (Transact-SQL)

SQL Server TechCenter

Troubleshooting

Product Information

Printer Friendly Version

Send

TechNet Library

TechNet Library

Server 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

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 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