SQL SERVER CLR UrlDecode



sp_configure 'clr enabled', 0
go
reconfigure
go

alter database FetchData set trustworthy on

exec sp_changedbowner 'sa'
CREATE ASSEMBLY 
  [System.Web] from 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\System.Web.dll'
  with permission_set = UNSAFE --Fails if not 64 on 64 bit machines

  GO

创建应用程序集

CREATE ASSEMBLY CLR_URLDECODE from 'D:\Microsoft SQL Server\MSSQL\CLR\SQLSERVER_CLR.dll'

create function UF_Scalar_SayHelloByPar(@Par nvarchar(1000))
returns nvarchar(1000)
as EXTERNAL NAME CLR_URLDECODE.UserDefinedFunctions.CLR_URLDECODE
go

select dbo.UF_Scalar_SayHelloByPar(dm) from dbo.nanjing_uniturlsplitdistinct

update nanjing_uniturlsplitdistinct set dm=dbo.UF_Scalar_SayHelloByPar(dm)