SQL Server 2008 SELECT * FROM @variable?

Question

It is possible?

DECLARE @vTableName varchar(50)

SET @vTableName = (SELECT TableName FROM qms_Types WHERE Id = 1)

SELECT * FROM @vTableName

I have this error:

Msg 1087, Level 16, State 1, Line 3 Must declare the table variable "@vTableName".

Answer 1

my solution for this:

EXECUTE('SELECT * FROM  ' + TableName + '')