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)