using System;
using System.Data;
using System.Data.SqlClient;

namespace CaseTest
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=tempdb;Integrated Security=True");
            SqlCommand sqlt = new SqlCommand("create procedure CaseTest	@P int AS select case when @p> 0 then 1 else 0 end", con);
            SqlCommand sqlp = new SqlCommand("CaseTest", con);
            sqlp.CommandType = CommandType.StoredProcedure;
            sqlp.Parameters.AddWithValue("@p", 100);
            con.Open();
            sqlt.ExecuteNonQuery();
            Console.WriteLine(sqlp.ExecuteScalar());
            sqlt.CommandText = "drop procedure CaseTest";
            sqlt.ExecuteNonQuery();
            con.Close();

        }
    }
}