Update Records Using Stored Procedure In SQL 2008

In this article i will explain how to update records in table with the help of Parameterized Stored Procedure.
  • 2540


Parameterized Stored Procedure

These accept one or more Parameters. It is important that data type of parameters should be same as the data type in tables.

Parameterized Stored Procedure for Update

Using Stored Procedure we can update records in table. Following example explains , how to update records using parameterized stored procedure.


Suppose we have table named Employee as.


Suppose, I want to update salary of "Amit Kumar" to 40000. To do this, create  stored procedure for update


Execute Stored Procedure.


After executing the above query the salary of "Amit Kumar" will be updated to 40000 in the table.


© 2020 DotNetHeaven. All rights reserved.