Code: Select all
DECLARE @table_name VARCHAR(50);
SELECT table_name
FROM my_tables
WHERE id = 4;
SELECT *
FROM @table_name
WHERE 1 = 1;Moderator: General Moderators
Code: Select all
DECLARE @table_name VARCHAR(50);
SELECT table_name
FROM my_tables
WHERE id = 4;
SELECT *
FROM @table_name
WHERE 1 = 1;Code: Select all
DECLARE @table_name VARCHAR(50);
DECLARE @sql VARCHAR(150);
SELECT table_name
FROM my_tables
WHERE id = 4;
SELECT @sql = 'SELECT * FROM [' + @table_name + '] WHERE 1 = 1';
EXEC @sql;