Table Name as Variable

[stevenk140]

How come this will not work?

DECLARE @TableName VARCHAR(40)
SET @TableName = 'analog'
SELECT * FROM @TableName

Server: Msg 137, Level 15, State 2, Line 5
Must declare the variable '@TableName'.


How could I get around this?

 

[nigelrivett]

declare @sql varchar(1000)
select @sql = 'select * from ' + @TableName
exec (@sql)


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[stevenk140]

Thank you.