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
authorization dbo
from 'C:\Users\Administrator\Desktop\MyClr.dll'
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1';
go
ALTER DATABASE AADB set TRUSTWORTHY on;
---在执行完这里后千万不要干别的,直接执行下面的
create assembly MyClrauthorization dbo
from 'C:\Users\Administrator\Desktop\MyClr.dll'
WITH permission_set = UNSAFE;
1、上图所示,函数代码没有命名空间
2、函数定义有个partial