SQL CLR

exec sp_configure 'clr enabled',1启动用sql clr

CREATE FUNCTION dbo.clrHelloWorld   

(   

    @name as nvarchar(200)   

)    

RETURNS nvarchar(200)   

AS EXTERNAL NAME asmHelloWorld.[SQLServerCLRTest.CLRFunctions].HelloWorld 

create assembly hell from 'c:\aaaa\hello.dll' with permission_set = safe