exec sp_configure 'clr enabled', 1
reconfigure
GO
use BaiduMapDb
GO
alter database [BaiduMapDb]
set trustworthy on
CREATE ASSEMBLY [System.Web] FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Web.dll' WITH PERMISSION_SET = UNSAFE
create assembly UrlDecode from 'D:\Test VS Project\UrlDll\UrlDll\bin\Debug\UrlDecode.dll'
CREATE FUNCTION dbo.UrlDecodeStr
(
@url as nvarchar(500),
@key as nvarchar(120)
)
RETURNS nvarchar(200)
AS EXTERNAL NAME [UrlDecode].[UrlDecode.UrlDll].GetUrlPara
select dbo.UrlDecodeStr('bj.centanet.com/jingjiren/?key=%E5%86%B7%E5%85%83%E9%94%8B','key')
注意项
1.Sql的系统dll引用版本与.net的引用版本问题，如Sql system.web.dll 只支持2.0版本，C#只能引用2.0版本
2.以管理员身份引用
3.注意操作系统32/64 与 引用路径之间的区别