復制代碼 代碼如下:

public class CLRFunctions
{
public static string HelloWorld(string Name)
{
return ("Hello " + Name);
}
}

復制代碼 代碼如下:

C:/Documents and Settings/mark.smith/My Documents/Visual Studio 2005/Projects/SQLServerCLRTest/SQLServerCLRTest/bin/Debug/SQLServerCLRTest.dll

復制代碼 代碼如下:

exec sp_configure 'clr enabled',1
reconfigure
go

復制代碼 代碼如下:

CREATE ASSEMBLY asmHelloWorld FROM 'C:/SQLServerCLRTest.dll'

復制代碼 代碼如下:

CREATE FUNCTION dbo.clrHelloWorld
(
@name as nvarchar(200)
)
RETURNS nvarchar(200)
AS EXTERNAL NAME asmHelloWorld.[SQLServerCLRTest.CLRFunctions].HelloWorld

復制代碼 代碼如下:

SELECT dbo.clrHelloWorld('Mark')