Unable to pass a variable as table name in sql command text

Question

I am trying to pass the variable as a table name in sql command text. This is code i tried

string tableName = string.Empty;

for (int m = dateDebut.Month; m <= dateFin.Month; m++)
{
    sqlCommand.Parameters.Clear();
    tableName = "DynamicPosition" + m;

    sqlCommand.CommandText = "SELECT ProfileId, FloorId FROM @tableName WHERE ProfileId = @profileId AND LastUpdate >= @dateDebut AND LastUpdate <= @dateFin";

    sqlCommand.Parameters.AddWithValue("@tableName", tableName);
}

This is the error I am getting

Must declare the table variable \"@tableName\"

score 2 · Answer 1 · edited Jan 07 '22 at 13:38

Parameter passing is for passing in constant ("literal") values. You are not allowed to pass in anything else. This includes:

server/database/schema/table names
column names
function names
operators
SQL keywords

Your only real solution is to "munge" the query string, substituting the table name before you pass it to the database. Alternatively, you can design the database so this is not necessary.

Unable to pass a variable as table name in sql command text

1 Answers1