CLR存储过程

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void sp_MyClrProc(string name)
    {
        using (SqlConnection conn &＃61; new SqlConnection("context connection&＃61;true"))
        {
            SqlCommand cmd &＃61; new SqlCommand();
            SqlParameter param &＃61; new SqlParameter("&＃64;Name", SqlDbType.NVarChar);

            param.Value &＃61; name;
            cmd.Parameters.Add(param);
            cmd.CommandText &＃61; "select &＃39;Hello: &＃39; &＃43; &＃64;Name as [Greeting]";
            cmd.Connection &＃61; conn;
            conn.Open();
            SqlDataReader dr &＃61; cmd.ExecuteReader();
            SqlContext.Pipe.Send(dr);
            conn.Close();
        }
    }
};

sp_configure &＃39;clr enabled&＃39;, 1
reconfigure

Greeting   
-----------
Hello: Mike