how to update record by id using stored procedure

Question

plz update

Rijwan Ansari · Answer

Create SP like sample shown: CREATE PROCEDURE [dbo].[SpUpdateTable] @Id bigint ,@RegionId bigint ,@Code nvarchar(150) ,@Name nvarchar(150) ,@Active bit ,@Editor bigint ,@Modified datetime ,@Author bigint ,@Created datetime AS BEGIN UPDATE [dbo].[TableName] WITH(XLOCK,ROWLOCK) SET [RegionId] = @RegionId ,[Name]= @Name ,[Code]=@Code ,[Active] = @Active ,[Editor] = @Editor ,[Modified] = @Modified WHERE Id = @Id SELECT @Id; END GO Execute it in your code as shared by Sachin. Yes, You can update multiple records in one action.

Sachin Singh · Answer

Stored Procedure create procedure spUpdateEmployee @Id int , @Name varchar(50), @DepId int as begin update tblEmployee set Name=@Name, DepartmentId=@DepId where Id=@Id end protected void Button1_Click( object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(cs)) { //Create the SqlCommand object SqlCommand cmd = new SqlCommand( "spUpdateEmployee" , con); //Specify that the SqlCommand is a stored procedure cmd.CommandType = CommandType.StoredProcedure; //Add the input parameters to the command object cmd.Parameters.AddWithValue( "@Id" ,txtId.Text); cmd.Parameters.AddWithValue( "@Name" ,txtName.Text); cmd.Parameters.AddWithValue( "@DepId" , ddlDepartment.SelectedItem.Value); //Open the connection and execute the query con.Open(); cmd.ExecuteNonQuery(); } } please refer https://www.sharpencode.com/article/ADONET/stored-procedure-in-ado-net

Nikunj Satasiya · Answer

Hi Somesh, Please try this procedure, to update the record based on ID, at the time of calling this store procedure pass ID as Peramiter. CREATE PROCEDURE YourProcedureName @ID INT = 0 AS BEGIN UPDATE tblYourTableName WITH (NOLOCK) SET YourColumnName = 'Updated Value' WHERE Id = @ID END Calling Procedure EXEC YourProcedureName 3 Where 3 is your parameter ID. For more information about the stored procedure you can visit these articles: https://www.codingvila.com/2018/11/how-to-pass-output-parameter-to-stored-procedure-in-microsoft-sql-server.html https://www.codingvila.com/search/label/Stored%20Procedure Thank you.

somesh kunder · Answer

one or more table record update with one action result

how to update record by id using stored procedure

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)