Re: Can I use a dynamic table name in stored procedure

[Martin Leboeuf]

Hi !

Thanks for the tip to construct my SQL dynamically with CONCAT(). Modify your SP as follows and it will work:

set @num_v_tmp=-1
set @dyn_sql=CONCAT('select count(*) into @dyn_v_tmp ...');
...
-- and then use @dyn_v_tmp e.g. to set your return variable.

Cheers,

Martin.