22,210
社区成员
发帖
与我相关
我的任务
分享
--开启CLR
exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1';
go
use DB_Test
--配置SA数据权限
alter database DB_TEST set TRUSTWORTHY on
EXEC sp_changedbowner 'sa'
--创建程序集
create ASSEMBLY MSExcel FROM 'C:\sql\Microsoft.Office.Interop.Excel.dll' --如:F:\InterfaceFile\Easyway.ISP.Proxy.dll
WITH PERMISSION_SET = unSAFE;
go
create ASSEMBLY EXCELTEST FROM 'C:\sql\excelDS.dll' --如:F:\InterfaceFile\Easyway.ISP.Proxy.dll
WITH PERMISSION_SET = unSAFE;
go