Breaking News: Grepper is joining You.com. Read the official announcement!

stored procedure with input and output parameters

Add Answer

Nanu answered on November 29, 2020 Popularity 7/10 Helpfulness 2/10

answer stored procedure with input and output parameters

related output parameter use with stored procedure

stored procedure with input and output parameters

Comment

stored procedure with input and output parameters

CREATE PROCEDURE spGetEmplloyeeNameById1
  @ID INT,
  @Name VARCHAR(30) OUTPUT
AS
BEGIN
  SELECT @Name = Name FROM Employee WHERE ID = @ID
END
GO
-- For calling the procedure:
DECLARE @EmployeeName VARCHAR(30)
EXECUTE spGetEmplloyeeNameById1 3, @EmployeeName OUTPUT
PRINT @EmployeeName

--C#

 string empName="";
            SqlConnection conn = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            conn.ConnectionString = _configuration.GetConnectionString("EmployeeAppCon");
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "GetName";
            cmd.Parameters.AddWithValue("@EmployeeID", id);

            cmd.Parameters.Add("@Name", SqlDbType.VarChar, 100);
            cmd.Parameters["@Name"].Direction = ParameterDirection.Output;
           
            try
            {
                conn.Open();
                int i = cmd.ExecuteNonQuery();
                //Storing the output parameters value in 3 different variables.  

                empName = Convert.ToString(cmd.Parameters["@Name"].Value);
               
                // Here we get all three values from database in above three variables.  
            }
            catch (Exception ex)
            {
                // throw the exception  
            }
            finally
            {
                conn.Close();
            }
            return empName;

Popularity 7/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: input procedure whatever

Link to this answer
Share Copy Link

Contributed on Apr 11 2023

Nanu

0 Answers Avg Quality 2/10

Closely Related Answers

output parameter use with stored procedure

Comment

        
            
        
     CREATE PROCEDURE uspFindProductByModel (
    @model_year SMALLINT,
    @product_count INT OUTPUT
) AS
BEGIN
    SELECT 
        product_name,
        list_price
    FROM
        production.products
    WHERE
        model_year = @model_year;

    SELECT @product_count = @@ROWCOUNT;
END;

Popularity 10/10 Helpfulness 3/10 Language whatever

Source: www.sqlservertutorial.net

Tags: output-parameter outp

Link to this answer
Share Copy Link

Contributed on Nov 29 2020

Mushy Mockingbird

0 Answers Avg Quality 2/10

stored procedure with input and output parameters

Contents

More Related Answers

stored procedure with input and output parameters

Closely Related Answers

output parameter use with stored procedure

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.