you can try this
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE StoredProcedureName
@action varchar(10),
@empid int,
@emp_name varchar(50),
@emp_phno char(10),
@emp_add varchar(75)
AS
IF @action ='Save'
BEGIN
INSERT INTO TabelName (emp_name,emp_phno,emp_add)
VALUES (@emp_name,@emp_phno,@emp_add)
END
ELSE IF @action ='Update'
BEGIN
UPDATE TabelName SET
emp_name = @emp_name,
emp_phno = @emp_phno,
emp_add = @emp_add
WHERE (empid = @empid)
END
ELSE IF @action ='Delete'
BEGIN
DELETE FROM TabelName
WHERE (empid = @empid)
End