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.
Introduction
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.
Example
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.