Hi all .
I have a problem that i can not solve for so long already . Do anyone know how to Select a table from a variable  ( not use table variable ) .
Example :

Declare @fName varchar(16)
Set @fName =  'customer'
Select * from @fName

This one does not work,  of course . Do anyone know how to solve it  ( not Exec ('select * from' + @fName) ) . Or anyone can explain for me that why the code above return this message  : Must declare the variable @fname . ?
Regards .

You've declared a nice scalar variable called @FName. You've then used a table variable called @FName. This confused SQL Server, because it couldn't find a table variable called @Fname. I realise that the error  message is misleading. It should be '@fname used as a table variable when defined as a scalar.
Try:

DECLARE @fName VARCHAR(16)
SET @fName = 'customer'
SELECT [customer]= @fName