Take a look at this. I have created a sample one. Change it based on your need
CREATE PROCEDURE Usp_SingleProcedureForAllOperations
(
@EmpID INT,
@EmpName VARCHAR(10),
@Status CHAR(1),
@Mode VARCHAR(10),
@Result INT OUT
)
AS
IF @Mode='INSERT'
BEGIN
INSERT INTO Emp(EmpID,EmpName,Status) VALUES(@EmpID,@EmpName,@Status)
SET @Result=1
END
ELSE IF @Mode='UPDATE'
BEGIN
UPDATE Emp SET
EmpName=@EmpName,
Status=@Status
WHERE
EmpID=@EmpID
SET @Result=1
END
ELSE IF @Mode='DELETE'
BEGIN
DELETE Emp WHERE EmpID=@EmpID
SET @Result=1
END
RETURN @Result
IF @@ERROR<>0
SET @Result=@@ERROR
GO