Sqlserver 中调用C# 进行加密解密字符串.

 

从https://download.youkuaiyun.com/download/cj201707/10562962下载c#程序, 在sqlserver 中运行一下sql.

 

--启用clr

exec sp_configure 'clr enabled',1

reconfigure

go

 

        CREATE ASSEMBLY SQLEncrpyt FROM 'SQLEncryption.dll'

        CREATE FUNCTION dbo.SQLEncrpyt

        (

        @name as nvarchar(2000),

        @key as nvarchar(2000)

        )

        RETURNS nvarchar(2000)

        AS EXTERNAL NAME SQLEncrpyt.[SQLEncryption.Encryption].Encrypt

 

--测试

        SELECT  dbo.SQLEncrpyt('fdasf','123456789')

                  

        CREATE FUNCTION dbo.SQLDecrypt

        (

        @name as nvarchar(2000),

        @key as nvarchar(2000)

        )

        RETURNS nvarchar(2000)

        AS EXTERNAL NAME SQLEncrpyt.[SQLEncryption.Encryption].Decrypt

 

--测试

        SELECT  dbo.SQLDecrypt('T0nDjXnbc2w=','12345678')