For this You have to take a @Action Varchar(30) parameter,
Write a single storeprocedure where you will use action type insert,update, delete
declare all types of paramter with a nullable type
and write your query as @Action type
Ex. create procedure usp_Category(
@Action varchar(30),
@id int=0,
@txt_category_name varchar(50)
)
AS BEGIN
if @Action ='Insert' begin
Insert into tblCategory(CategoryName)values(@txt_category_name)
end
if @Action ='Select' begin
Select category_i,txt_category_name from tblCategory
end
if @Action ='Delete begin
...so on
end
if @Action='Edit' begin
.... so on
end
END
<pre>