MSSQL数据加密解密代码建站知识
导读:1建站知识这个是一个简单的例子 里面还涉及到 如 对称密钥加密使用证书解密，没有涉及到seo网站关键词优化营销型网站建设。
可以查看：
复制代码 代码如下:
OPEN SYMMETRIC KEY 命令关于 对称密钥加密使用证书解密 CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'如何seo优化推广网站 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 ENCRYPT网站推广优化seoBYASYMKEY(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 .o网站seo优化课程bjects
相关seo网站关键词优化营销型网站建设。声明: 本文由我的SEOUC技术文章主页发布于:2023-05-24 ，文章MSSQL数据加密解密代码建站知识主要讲述加密解密,代码,SQL网站建设源码以及服务器配置搭建相关技术文章。转载请保留链接: https://www.seouc.com/article/web_6459.html
