SQL: Execute a list of stored procedures

exec-list-of-stored-procs.sql

USE [someDb];
GO;

DECLARE @table Table (id INT IDENTITY(1,1), item NVARCHAR(255) NOT NULL)
;

INSERT INTO @table (item)
  SELECT someColumn
  FROM someConfigurationTable
  WHERE anotherColumn = 'stored_proc'
  ORDER BY someColumn
;

DECLARE 
  @x NVARCHAR(255)
  , @idx INT = 0
  , @totalRecords INT = (SELECT COUNT(*) FROM @table)
;

WHILE @idx < @totalRecords
BEGIN
	SET @idx = @idx + 1;
	SET @x = (SELECT item FROM @table WHERE id = @idx);
	PRINT 'Executing: ' + @x -- output the stored proc that will be executed
	EXEC (@x); -- the parenthesis are necessary
END
;