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

sql server execute stored procedure with table parameter

Add Answer

Yawning Yak answered on April 13, 2021 Popularity 9/10 Helpfulness 1/10

answer sql server execute stored procedure with table parameter

related sql server execute stored procedure with parameters

related sql stored procedure with table parameter

related sql command to execute stored procedure with parameters c#

related run stored procedure sql

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 procedure sql sql-server

Link to this answer
Share Copy Link

Contributed on Aug 31 2023

Yawning Yak

0 Answers Avg Quality 2/10

Closely Related Answers

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

Link to this answer
Share Copy Link

Contributed on May 15 2021

VasteMonde

0 Answers Avg Quality 2/10

sql stored procedure with table parameter

Comment

CREATE PROC usp_PassTable
    @Keys KeyTable READONLY
AS
BEGIN
    SET NOCOUNT ON
    SELECT * FROM @Keys
END
GO

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: procedure proc

Link to this answer
Share Copy Link

Contributed on May 06 2022

Wild Weasel

0 Answers Avg Quality 2/10

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

run stored procedure sql

Comment

-2

-- Datagrip: 
call MY_SCHEMA.my_procedure();
-- SQL Developer
exec MY_SCHEMA.my_procedure();
-- Shorter than :
BEGIN
	MY_SCHEMA.my_procedure();
END;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: procedure proc

Link to this answer
Share Copy Link

Contributed on Apr 13 2021

VasteMonde

0 Answers Avg Quality 2/10

sql server execute stored procedure with table parameter

Contents

More Related Answers

sql server execute stored procedure with table parameter

Closely Related Answers

sql server execute stored procedure with parameters

sql stored procedure with table parameter

sql command to execute stored procedure with parameters c#

run stored procedure sql

Grepper

Documentation

Social

Legal

Contact

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