Transact-SQL using variable for table name

Question

I have try to use statement below in my SQL. Is it possible by any means to dynamically select table form database. (For example select table name from Comobox and then display data from selected table)

SET @var1 = 'test';
SELECT * From @var1

If you need to refer to your tablename by variable, chances are that your design needs rethinking — t-clausen.dk, Jun 30 '13 at 20:55

score -2 · Answer 1 · edited May 23 '17 at 12:01

-2

Dynamic SQL requires that you create a string consisting of the sql statement, and then you execute the string. Dynamic t-sql quotes in string

edited May 23 '17 at 12:01

Community

1
1

answered Jun 30 '13 at 20:24

Tim

8,669
31
105
183

Thak you for your answer. Can you give me short example. – Sysrq147 Jun 30 '13 at 20:26

Transact-SQL using variable for table name

1 Answers1