密碼編譯函式 (Transact-SQL)

適用於：SQL ServerAzure SQL 資料庫 Azure SQL 受控執行個體

這些函數支援數字簽章、數字簽章驗證、加密和解密。

對稱式加密和解密

ENCRYPTBYKEY

DECRYPTBYKEY

ENCRYPTBYPASSPHRASE

DECRYPTBYPASSPHRASE

KEY_ID

KEY_GUID

DECRYPTBYKEYAUTOASYMKEY

KEY_NAME

SYMKEYPROPERTY

 

非對稱式加密和解密

ENCRYPTBYASYMKEY

DECRYPTBYASYMKEY

ENCRYPTBYCERT

DECRYPTBYCERT

ASYMKEYPROPERTY

ASYMKEY_ID

 

簽署和簽章驗證

SIGNBYASYMKEY

VERIFYSIGNEDBYASYMKEY

SIGNBYCERT

VERIFYSIGNEDBYCERT

IS_OBJECTSIGNED

 

對稱式解密，利用自動金鑰處理

DecryptByKeyAutoCert

 

加密雜湊

HASHBYTES

 

憑證複製

CERTENCODED (Transact-SQL)

CERTPRIVATEKEY (Transact-SQL)

 

請參閱

函式
加密階層
權限階層 (Database Engine)
CREATE CERTIFICATE (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
安全性目錄檢視 (Transact-SQL)