Using sp_ExecuteSQL and passing Table Name

[Pargat]

I am creating a dynamic sql statement in a stored procedure.
The stored procedure has table name passed in.
I cannot pass in the table name as a parameter.

How do I pass the table name as a paramter is a dynamic sql statement

[Jim W]

The only way to specify a table name is by building a query string and running exec, as in exec("select * from " + @mytable)


------------
Pargat at 1/11/01 10:50:18 AM

I am creating a dynamic sql statement in a stored procedure.
The stored procedure has table name passed in.
I cannot pass in the table name as a parameter.

How do I pass the table name as a paramter is a dynamic sql statement