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

从https://download.csdn.net/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')