ALTER Procedure [dbo].[crud_operation]
	@TableName VarChar(100),
	@id int=null,
	@action int,@COL1 sysname=null,@COL2 sysname=null,@cval1 nvarchar(max)=null,@cval2 nvarchar(max)=null
AS

Declare @SQL VarChar(1000)
----simple select--
 
SELECT @SQL = case
 when (@action = 0 and @id is null) then  'SELECT * FROM ' + @TableName
 when (@action=0 and  @id is not null) then 'SELECT * FROM ' + @TableName +' '+ N'where id=' + rtrim(cast (@id as int))
----insert----
 when (@action=1 and @COL1 is not null and @COL2 is null) then 'insert into ' + @TableName + ' ' +'('+@COL1+')' + ' ' + 'select '+ ''''+@cval1+''''
 when (@action=1 and @COL1 is not null and @COL2 is not null) then
 'insert into ' + @TableName + '('+@COL1+','+@COL2 + ')' + ' ' + 'select '+ ''''+@cval1+'''' +','+''''+@cval2+''''
----delete----
   when(@action=2 and @id is not null) then
 'delete from ' + @TableName + ' ' + N'where id='+ rtrim(cast(@id as int))
----update ---
when (@action=3 and @id is not null and (@COL1 is not null and @COL2 is null))
   then 'update ' + @TableName + ' set ' +  @COL1 + '=' + @cval1 +' where id=' + rtrim(cast(@id as int)) 

else '' end
print @sql
Exec ( @SQL)