SQL CLR

using System;
using System.Data;
using System.Data.SqlTypes;

public class MyCLRFunc
{
[Microsoft.SqlServer.Server.SqlFunction]
public static SqlString MyCLRHelloFunction()
{
return new SqlString("Hello everybody, I'm form SQLCLR!");
}
};



Create assembly MyUDFCLR from 'K:\Users\Sudesh\Desktop\MyCLRFunc.dll'

create function MyCLRHelloFunction()
Returns nvarchar(50)
External name MyUDFCLR.MyCLRFunc.MyCLRHelloFunction;
Go

select dbo.MyCLRHelloFunction()