sql server - Assigning values to parameter of one stored procedure using another stored procedure -

i want create stored procedure take values in @table_name, @column_name @param1 , @param2 , assign values @tabletobeexecuted abc_@param1_@param2_queries.

... exec [dbo].[sp_createtable]      @table_name='career',      @column_name = 'profession',      @tabletobeexecuted = 'abc_career_profession_queries'   go ... 

i tried in way not value assigned desired.

... exec [dbo].[sp_createtable]      @table_name='@param1',      @column_name = '@param2',      @tabletobeexecuted = 'abc_'+@param1+'_'+@param2+'_queries'   go ... 

no need parameter. should create local variable in sp.

alter procedure [dbo].[sp_createtabl]     @table_name nvarchar(max),     @column_name nvarchar(max) begin        declare @tabletobeexecuted  nvarchar(max) = 'abc_' + @table_name + '_' + @column_name + '_queries'     -- sp code here..  end