MSSQL数据加密解密代码

复制代码 代码如下:

OPEN SYMMETRIC KEY 命令关于 对称密钥加密使用证书解密

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'

go

CREATE CERTIFICATE CertTest

with SUBJECT = 'Test Certificate'

GO

--创建非对称密钥

CREATE ASYMMETRIC KEY TestAsymmetric

WITH ALGORITHM = RSA_2048

ENCRYPTION BY PASSWORD = 'password1' ;

GO

ALTER ASYMMETRIC KEY TestAsymmetric WITH PRIVATE KEY (DECRYPTION BY PASSWORD = 'password1')

--DROP ASYMMETRIC KEY TestAsymmetric

--创建对称密钥

CREATE SYMMETRIC KEY TestSymmetric

WITH ALGORITHM = AES_256

ENCRYPTION BY PASSWORD = 'password' ;

GO

OPEN SYMMETRIC KEY TestSymmetric

DECRYPTION BY PASSWORD = 'password' ;

go

SELECT

ENCRYPTBYASYMKEY(ASYMKEY_ID ('TestAsymmetric'), name) ,

CAST(deCRYPTBYASYMKEY (ASYMKEY_ID( 'TestAsymmetric'),ENCRYPTBYASYMKEY (ASYMKEY_ID( 'TestAsymmetric'),name ) )

as nvarchar(200 )),

ENCRYPTBYCERT ( Cert_ID('CertTest' ),name),

CAST(deCRYPTBYCERT (Cert_ID ('CertTest'), ENCRYPTBYCERT (Cert_ID( 'CertTest'),name ))

as nvarchar (200)),

EncryptByKey ( KEY_GUID('TestSymmetric' ),name),

CAST(decryptByKey (EncryptByKey (KEY_GUID ('TestSymmetric'), name))

as nvarchar (200))

FROM sys .objects

如有侵权，请发邮件到 [emailprotected]

（编辑：天瑞地安资讯网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!