Execute stored procedure named as a string

Question

How can I execute a stored procedure named as a string

I tried this:

EXEC CAST(@GetDD AS StoredProcedure);

Answer 1

Create a dynamic SQL string, and execute that:

declare @sql varchar(512);
set @sql = 'exec ' + @GetDD;
EXEC (@sql);