Create a bunch of databases in a loop

CreateDatabases

DECLARE @StringTemplate VARCHAR(1000);
DECLARE @StringToExecute VARCHAR(1000);
DECLARE @Counter TINYINT = 1;
SET @StringTemplate = 'CREATE DATABASE [ConsumeMassQuantities##REPLACE##]
CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N''ConsumeMassQuantities'', FILENAME = N''D:\MSSQL\Data\ConsumeMassQuantities##REPLACE##.mdf'' , SIZE = 8192KB , FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N''ConsumeMassQuantities_log'', FILENAME = N''D:\MSSQL\Data\ConsumeMassQuantities##REPLACE##_log.ldf'' , SIZE = 8192KB , FILEGROWTH = 65536KB )'

WHILE @Counter < 100
	BEGIN
	SET @StringToExecute = REPLACE(@StringTemplate, '##REPLACE##', @Counter)
	EXEC (@StringToExecute);
	SET @Counter = @Counter + 1;
	END
GO