手机
当前位置:查字典教程网 >编程开发 >mssql数据库 >MSSQL数据加密解密代码
MSSQL数据加密解密代码
摘要:可以查看:复制代码代码如下:OPENSYMMETRICKEY命令关于对称密钥加密使用证书解密CREATEMASTERKEYENCRYPTIO...

可以查看:

复制代码 代码如下:

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

【MSSQL数据加密解密代码】相关文章:

SQLServer数据库bcp导出备份文件应用

SQLserver 2008将数据导出到Sql脚本文件的方法

SQL Server 数据库备份和还原认识和总结

SQL Server 数据库优化

SQL 截取字符串应用代码

获取MSSQL数据字典的SQL语句

SQL Server 大量数据的分页存储过程代码

SQL SERVER 2008数据库引擎详细介绍

创建动态MSSQL数据库表

SQL Server数据库中的存储过程介绍

精品推荐
分类导航