create proc test
@pValue nvarchar(20),
@pAction int
as
begin
   delcare passedvalues nvarchar(20)
   set passedvalues = '' -- something your want.
   -- insert
   if @pAction =1 
   insert into tb values(@pValue)
   
   if @pAction =2
   update tb set col = @pValue 
  
   if @pAction =3
   delete from tb where col =@pValue

   if @pAction =4 
   select col from tb

   print passedvalues 
   
end