当前位置： 移动技术网 > IT编程>数据库>MSSQL > MSSQL数据加密解密代码

MSSQL数据加密解密代码

2017年12月12日  | 移动技术网IT编程  | 我要评论

真假千金 铭恩,邪恶力量第一季爱奇艺,哈尔滨二手房买卖

可以查看：
复制代码 代码如下:

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

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网