Avatar of sweoff

asked on 

Query a table with a list of stored procedures and execute that SP within another SP by passing SP Name and parameteres of it

Is it or would be possible to create stored procedure that could have a list of parameters to pass the stored procedure name to run and the parameters it needs to run it?

I need to create a table to define a list of stored procedure names, their parameter names, and the parameter types within a table. As the plan is to call the specified SP from a query to select another SP from the list based on certain selection criteria. Is this even possible and if so how would I go about this? Would there or could there be any possible bottle necks from doing this?
Microsoft SQL ServerMicrosoft SQL Server 2008Programming Theory

Avatar of undefined
Last Comment
Walter Padrón

8/22/2022 - Mon