ok so i can create a command where it inserts a table in to my connection string using the following sql command:
"CREATE TABLE myTable" KEY,"
but what i want to do is not have a static table but so it changes and sets the table name to whatever is in the SQL parameter or variable.. here are a few ways i have tried:
"CREATE TABLE @sqlParameter"
"CREATE TABLE (@sqlParameter)"
"CREATE TABLE " + @sqlParameter
"CREATE TABLE " & @sqlParameter
now do i have to do this in a stored procedure or what? can some one please point me in the right direction