Home Forums SQL Server 2005 T-SQL (SS2K5) Must declare the table variable "@tableName". RE: Must declare the table variable "@tableName".
Andras Belokosztolszki
SSC-Insane
Points: 21971
More actions
November 30, 2007 at 5:23 am
#755897
You could use dynamic SQL like:
declare @q varchar(1000)
set @q = 'SELECT * FROM ' + @tableName
exec (@q)
Regards,
Andras