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)?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You can use the variable directly:
Please see the BOL Reference on
A procedure name is an identifier name in SQL Server, and it follows the rules of the database identifiers. For object names I prefer to use the special data type sysname (a synonym for NVARCHAR(128)).
PS: see @ThomasStringer's example on an execution.
PS2: if later you'll need to add parameters, the best way to do that is to execute with sp_executesql.