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網站建設源碼以及服務器配置搭建相關技術文章。轉載請保留鏈接: http://www.bifwcx.com/article/web_6459.html
