526互联

CLR SQL 调用C#方法

发布时间 2023-03-28 12:05:43作者: 码农小白修炼记
EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
GO
 
ALTER DATABASE INFOSHARE_BASE_TRAINING SET TRUSTWORTHY ON;
GO


IF EXISTS (SELECT name FROM sys.assemblies WHERE name = 'clr_Bussiness')
   DROP ASSEMBLY clr_Bussiness

CREATE ASSEMBLY clr_Bussiness
FROM 'D:\bin\Debug\ClrBusiness.dll'
WITH PERMISSION_SET = UNSAFE;
GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'usp_Encode')
   DROP PROCEDURE usp_Encode;


 CREATE PROCEDURE [dbo].usp_Encode
   
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [clr_Bussiness].[ClrBusiness.EncodeHelper].[DoWork];   
GO


SELECT * FROM sys.assemblies