CREATE PROCEDURE get_word_id_from_vocabulary (@SearchWord NVARCHAR(50), @CaseSensitive BIT, @WordID int output)
AS

BEGIN
   
IF @CaseSensitive=1

SELECT @WordID=WordSheet.WordID
FROM
  dbo.WordSheet
WHERE
  Word = @SearchWord COLLATE SQL_Latin1_General_CP1_CS_AS
ELSE 
  SELECT @WordID=WordSheet.WordID
  FROM
    dbo.WordSheet
  WHERE
    Word = @SearchWord COLLATE SQL_Latin1_General_CP1_CI_AS
      
  RETURN
END

SqlCommand cmd = new SqlCommand("get_word_id_from_vocabulary", cn);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;

                    //Передаю в качестве параметра строку - искомое слово
                    SqlParameter param = new SqlParameter();
                    param.ParameterName = "@SearchWord";
                    param.SqlDbType = System.Data.SqlDbType.NVarChar;
                    param.Value = Word;
                    param.Direction = System.Data.ParameterDirection.Input;
                    cmd.Parameters.Add(param);

                    //Передаю в качестве параметра bit - флаг чуствительность к регистру
                    SqlParameter param2 = new SqlParameter();
                    param2.ParameterName = "@CaseSensitive";
                    param2.SqlDbType = System.Data.SqlDbType.Bit;
                    param2.Value = (bool) CaseSensitive;
                    param2.Direction = System.Data.ParameterDirection.Input;
                    cmd.Parameters.Add(param2);
                    
                    //Выходной параметр int - WordID слова  Word в таблице WordSheet
                    SqlParameter param3 = new SqlParameter();
                    param3.ParameterName = "@WordID";
                    param3.SqlDbType = System.Data.SqlDbType.Int;
                    param3.Value = 0;
                    param3.Direction = System.Data.ParameterDirection.Output;
                    cmd.Parameters.Add(param3);
                    
                    cmd.ExecuteNonQuery();

                    exitcode = (int)cmd.Parameters["@WordID"].Value;