前面寫了一篇《帶參數的CLR存儲過程》http://www.cnblogs.com/insus/p/4373605.html ，如果我們需要創建一個帶OUTPUT返回值。實現它，可以先了解一下C#的OUT關鍵詞

打開剛才前面我們寫好的SQL DataBase PRoject，添加一個方法：

可復制代碼：

 public static void GetFruitName(out SqlString fruitName, SqlByte fruit_nbr )    {        SqlConnection connection = new SqlConnection("Context connection=true");        connection.Open();        SqlCommand command = new SqlCommand();        command.Connection = connection;        string sql = "SELECT [FruitName] FROM [dbo].[Fruit] WHERE [Fruit_nbr] = @Fruit_nbr";        command.CommandText = sql;        SqlParameter param = new SqlParameter("@Fruit_nbr", SqlDbType.TinyInt);        param.Value = fruit_nbr;        command.Parameters.Add(param);        try        {            string scalarValue = (string)command.ExecuteScalar();            fruitName = (SqlString)scalarValue;        }        catch         {            fruitName = string.Empty;        }        connection.Close();    }

Build solution，然后找開Microsoft SQL Server management studio，重新部署Assembly以及Clr stored procedure。參考前兩篇《簡單創建與布署CLR存儲過程》http://www.cnblogs.com/insus/p/4371762.html 和 《帶參數的CLR存儲過程》http://www.cnblogs.com/insus/p/4373605.html

執行存儲過程：