How can I execute a stored procedure whose name is in a variable?

Given a variable that contains a stored procedure name:

DECLARE @stored_procedure_name varchar(512);
SET @stored_procedure_name = 'some_stored_procedure_name';

How can I execute the stored procedure (without passing in any arguments)?

You can use the variable directly:

exec @stored_procedure_name;

Please see the BOL Reference on EXECUTE.

StackExchange Database Administrators Q#46980, answer score: 14