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

sql server execute stored procedure with parameters

Add Answer

VasteMonde answered on May 15, 2021 Popularity 10/10 Helpfulness 5/10

answer sql server execute stored procedure with parameters

related sql command to execute stored procedure with parameters c#

related sql server execute stored procedure with table parameter

sql server execute stored procedure with parameters

Comment

CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) AS
SELECT * FROM Person.Address WHERE City = @City

EXEC dbo.spGetAddress @City = 'Bordeaux'

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.mssqltips.com

Tags: execute parameters procedure sql sql-server

Link to this answer
Share Copy Link

Contributed on May 15 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

sql command to execute stored procedure with parameters c#

Comment

private static string connectionString = ConfigurationManager.ConnectionStrings["TestDB"].ConnectionString;
static SqlConnection conn = null;

public static void OpenConnection()
{
  conn = new SqlConnection(connectionString);
  conn.Open(); // open the connection
}

public static void CloseConnection()
{
  if (conn != null)
  {
    conn.Close(); // close the connction
    conn.Dispose(); // destroy the connection object
  }
}


// Open database connection before operation

// to insert or update table data:
string queryString = @"pr_insert_update";
SqlCommand command = new SqlCommand(queryString, conn);

SqlParameter TaskIdParam = new SqlParameter();
SqlParameter CreatedByIdParam = new SqlParameter();

TaskIdParam.ParameterName = "@TaskId";
TaskIdParam.SqlDbType = SqlDbType.Int;
TaskIdParam.Value = int.Parse(taskId.ToString());
command.Parameters.Add(TaskIdParam);

CreatedByIdParam.ParameterName = "@CreatedById";
CreatedByIdParam.SqlDbType = SqlDbType.Int;
CreatedByIdParam.Value = int.Parse(createdById.ToString());
command.Parameters.Add(CreatedByIdParam);

command.CommandType = CommandType.StoredProcedure;

command.ExecuteNonQuery();

// ======================================================
  string sql = "INSERT INTO TableName(Column1, Column2) " +
"VALUES(@Column1, @Column2)";

 using (SqlCommand cmd = new SqlCommand(sql, conn))
 {
   cmd.Parameters.AddWithValue("@Column1", "TestValue");
   if (String.IsNullOrEmpty(myObject.Column2))
     cmd.Parameters.AddWithValue("@Column2", DBNull.Value);
   else
     cmd.Parameters.AddWithValue("@Column2", myObject.Column2);
   
    cmd.CommandType = CommandType.Text;
    cmd.ExecuteNonQuery();
 }

//--------------------------------------------------------------
// ------------------ To get query data ------------------------  
List<string> emailNames = new List<string>();

 string queryString = @"pr_get_data";
SqlCommand command = new SqlCommand(queryString, conn);
SqlParameter TaskIdParam = new SqlParameter();

TaskIdParam.ParameterName = "@TaskId";
TaskIdParam.SqlDbType = SqlDbType.Int;
TaskIdParam.Value = int.Parse(taskId.ToString());
command.Parameters.Add(TaskIdParam);

command.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
  string emailName = null;
  if (reader["EmailName"] != null && reader["EmailName"] != DBNull.Value)
  {
    emailName = reader["EmailName"].ToString();
  }

  emailNames.Add(emailName);
}


-------------------------------------------------------- 
int id = 1;  
string queryString = @"SELECT * FROM TableName WHERE Id = " + id + " ";

SqlCommand command = new SqlCommand(queryString, conn);
SqlDataReader reader = command.ExecuteReader();

while (reader.Read())
{
  var id = Int32.Parse(reader["Id"].ToString());
}

Popularity 9/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# c

Link to this answer
Share Copy Link

Contributed on Jul 28 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

sql server execute stored procedure with table parameter

Comment

DECLARE @data ObjectList
INSERT @data (Id) VALUES (1)
EXEC GetData @data

Popularity 9/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: execute

Link to this answer
Share Copy Link

Contributed on Aug 31 2023

Yawning Yak

0 Answers Avg Quality 2/10

sql server execute stored procedure with parameters

Contents

More Related Answers

sql server execute stored procedure with parameters

Closely Related Answers

sql command to execute stored procedure with parameters c#

sql server execute stored procedure with table parameter

Grepper

Documentation

Social

Legal

Contact

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