SQL Server - 如何使用带有变量的'ALTER INDEX'作为参数

CREATE TABLE TestTable (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

CREATE INDEX idx_name ON TestTable (name);

DECLARE @tableName NVARCHAR(50) = 'TestTable';
DECLARE @indexName NVARCHAR(50) = 'idx_name';
DECLARE @rebuildOption NVARCHAR(50) = 'REBUILD';
DECLARE @partitionNumber INT = 1;

DECLARE @sql NVARCHAR(MAX);

SET @sql = 'ALTER INDEX ' + QUOTENAME(@indexName) + ' ON ' + QUOTENAME(@tableName) + ' ' + @rebuildOption + ' WITH (PARTITIONS = ' + CAST(@partitionNumber AS NVARCHAR(10)) + ')';

EXEC sp_executesql @sql;