Update records in database using Stored Procedure

In below code you can find, How to implement update query using Stored Procedure.


IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID=OBJECT_ID('UpdateProjectDetail'))
DROP PROCEDURE UpdateProjectDetail
GO

CREATE PROCEDURE UpdateProjectDetail
(
@piProjectID INT,
@piCustomerID INT,
@psProjectTitle VARCHAR(100),
@psProjectDescription VARCHAR(200),
@psProjectCategory INT,
@pdStartDate DATETIME,
@pdEndDate DATETIME,
@psStatus VARCHAR(10),
@piHours INT,
@piCreatedBy INT
)
AS
BEGIN
UPDATE projects SET

CustomerID=@piCustomerID,

ProjectTitle=@psProjectTitle,
ProjectDescription=@psProjectDescription,
ProjectCategory=@psProjectCategory,
StartDate=@pdStartDate,
EndDate=@pdEndDate,
Status=@psStatus,
Hours=@piHours,
CreatedBy=@piCreatedBy,
CreatedDate=GETDATE()

WHERE
ProjectID=@piProjectID
END
GO


Hope this post will help you,
Rajesh Singh
Asp.Net Developer
Indianic Infotech Ltd (India)
Rajesh@indianic.com