How to query a table whose link is stored in another table?

Question

SQL

Good afternoon.
There is a table consisting of three columns: id, dictionary name, link_to_dictionary.
The "link_to_dictionary" column stores the full name of the table it refers to.
Question: how can I make a query to a table using an existing link?

Answer 1

use dynamics:

DECLARE @tableName NVARCHAR(20); 
SELECT @tableName = dictionary_link FROM table1;

EXEC(' SELECT * FROM '[email protected]+' WHERE 1 = 1 ');

Next, you can take out the data in the temporary:

CREATE TABLE #test (id INT);
INSERT INTO #test EXEC(' SELECT id FROM '[email protected]+' WHERE 1 = 1 ');
-- или так:
EXEC(' SELECT id INTO #test FROM '[email protected]+' WHERE 1 = 1 ');

Answer 2

the one who designed this - castrate