其他人是对的，你需要使用动态SQL。这应该能让你得到你想要的东西，但是请注意，我还没有测试过。

CREATE PROC AddDatabase @Name varchar(100),
                        @FileName varchar(MAX),
                        @Size int,
                        @MaxSize int,
                        @FileGrowth int,
                        @LogName varchar(100),
                        @LogFileName varchar(MAX),
                        @LogSize int,
                        @LogMaxsize int,
                        @LogFileGrowth int
AS
    DECLARE @SQL nvarchar(MAX), @Params nvarchar(MAX);
    SET @SQL = N'
    CREATE DATABASE ' + QUOTENAME(@Name) + N' ON PRIMARY
        (NAME = @dName,
         FILENAME = @dFileName,
         SIZE = @dSize,
         MAXSIZE = @dMaxSize,
         FILEGROWTH = @dFileGrowth)
    LOG ON (NAME = @dLogName,
            FILENAME = @dLogFileName,
            SIZE = @dLogSize,
            MAXSIZE = @dLogMaxsize,
            FILEGROWTH = @dLogFileGrowth);';
    SET @Params = N'@dName varchar(100), @dFileName varchar(MAX), @dSize int, @dMaxSize int, @dFileGrowth int, @dLogName varchar(100), @dLogFileName varchar(MAX), @dLogSize int, @dLogMaxsize int, @dLogFileGrowth int';
    EXEC sp_executesql @SQL, @Params, @dName = @Name, @dFileName = @FileName, @dSize = @Size, @dMaxSize = @MaxSize, @dFileGrowth = @FileGrowth, @dLogName = @LogName, @dLogFileName = @LogFileName, @dLogSize = @LogSize, @dLogMaxsize = @LogMaxsize, @dLogFileGrowth = @LogFileGrowth;
GO

在MySQL 8.0.31中

DROP PROCEDURE IF EXISTS `spCreateDataBase`;

DELIMITER $$

CREATE PROCEDURE `spCreateDataBase`(NAME VARCHAR(255))

BEGIN

    SET @DB_CHARSET := ' DEFAULT CHARACTER SET UTF8MB4';
    SET @DB_COLLATE := ' DEFAULT COLLATE UTF8MB4_UNICODE_CI';

    SET @DROP_DB := CONCAT('DROP DATABASE IF EXISTS ', NAME);
    SET @CREATE_DB := CONCAT('CREATE DATABASE ', NAME, @DB_CHARSET, @DB_COLLATE);

    PREPARE DROP_STMT FROM @DROP_DB; EXECUTE DROP_STMT; DEALLOCATE PREPARE DROP_STMT;
    PREPARE CREATE_STMT FROM @CREATE_DB; EXECUTE CREATE_STMT; DEALLOCATE PREPARE CREATE_STMT;

END$$

DELIMITER ;