For example, there is a Monitor table in the Master database of the query analyzer.
I want to use a variable to get the table name, and then use this variable in the SELECT query statement. What should I do?
Declare @B VARCHAR (30)
SELECT @ b = 'Monitor'
Select * from @B The last sentence is to get the content of this table, but it is not, which prawn helps!