实现业务逻辑 如下:输入姓名和一个首字母，StoredProcedureTest将在Messages窗口显示欢迎信息在Results窗口显示从BookAuthors表中选出的作者名首字母符合条件的记录
public partial class StoredProcedures
{
    [SqlProcedure]
    public static void StoredProcedureTest(string name,string firstLetter)
    {
        SqlPipe myPipe = SqlContext.GetPipe();
        string strMsg = "Hello " + name.Trim() + " !";
        myPipe.Send(strMsg);
        SqlCommand myCommand = SqlContext.GetCommand();
        string strSQL =string.Format("select * from bookAuthors where authorname                         like '{0}%'",firstLetter);
        myCommand.CommandText = strSQL;
        myPipe.Send(myCommand.ExecuteReader());
    }
};

 
编译
1.IDE中 BUILD->Build Solution

2.手动编译
在Yukon beta中，System.Data.SqlServer命名空间所在的程序叫是SqlAccess.dll,可在命令提示符下使用如下命令编译上面的代码：
        csc.exe /t:library /r:"\sqlaccess.dll" /out:MyDllName.dll MySourceName.cs

 
部署
1.IDE中 BUILD->Deploy Solution
2.手动
            CREATE ASSEMBLY myAssemblyName FROM ‘path\MyDllName.dll'

            CREATE PROCEDURE myProcedureName(@parameter data_type)
                 AS EXTERNAL NAME assembly_name.Class_name .method_name