Creating update stored procedure….!
Hi All this is code for the stored procedure for updation…. ENJOY
First you have to declare the variable which recieve values with @ sign…… and for a variable which does not recieve value but get value from within the stored procedure, the keyword is DECLARE
so here’s the code this code needs 4 parameters which needs to be sent with the query…. and one is calculated one….
ASDECLARE @OldProjectID int SELECT @OldProjectID = ProjectID FROM TblProjects WHERE ProjectCode=@ChangerIndex UPDATE tblprojects SET ProjectName=@ProjectName,
ProjectCode=@projectCodeWHERE ProjectID=@OldProjectID RETURN
- Posted in: Visual Studio Tools for Office