存储过程调用一种方式

 public static String Is_UP_customers_Exists(string username)//1.系统默认
    {

        //创建数据库连接和命令的对象
        SqlConnection myConnection = new SqlConnection("server=.;uid=sa;pwd=sa;database=liyajun;");
        SqlCommand myCommand = new SqlCommand("UP_customers_Exists", myConnection);

        //指明Sql命令的操作类型是使用存储过程
        myCommand.CommandType = CommandType.StoredProcedure;

        //给存储过程添加参数
        SqlParameter parameterUsername = new SqlParameter("@name", SqlDbType.Char, 10);
        parameterUsername.Value = username;
        myCommand.Parameters.Add(parameterUsername);
SqlParameter paramOut = myCommand.Parameters.Add("@RETURN_VALUE", " ");
paramOut.Direction=ParameterDirection.ReturnValue; 

        //打开数据库连接
        myConnection.Open();
        //进行数据库操作
        myCommand.ExecuteNonQuery();
        //关闭数据库连接
        myConnection.Close();
        int userId = (int)myCommand.Parameters["@RETURN_VALUE"].Value;

        if (userId == 0)
        {
            return null;
        }
        else
        {
            return userId.ToString();
        }
    }

 

 

CREATE PROCEDURE UP_customers_Exists
@name char(10)

AS
 declare @TempID int
 SELECT @TempID = count(1) FROM [a] WHERE name=@name
 IF @TempID = 0
  RETURN 0
 ELSE
  RETURN 1
GO