stored procedure to update record in SQL Server 2008


In this post, we will discuss how to write a stored procedure that will update a record in the table. Also, you can check out my previous posts on:
Below are the steps for performing update operation in SQL server. This procedure will take 4 input parameters.
Right click on a stored procedure, then add new stored procedure
Create procedure sp_Update
@id integer,
@name varchar(20),
@add varchar(20),
@img varchar(20)
  As
     Update Emp_master set  emp_name=@name,emp_address=@add,emp_image=@img where emp_id=@id
Return
Here Table Name is Emp_master and Procedure name is sp_Update.
Then Save the stored procedure.
Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →