Hi,
can anyone tell me if is possible to refer to a table in a
FROM clause using a parameter.
Thanks,
Luca
can anyone tell me if is possible to refer to a table in a
FROM clause using a parameter.
Thanks,
Luca
No. To do this, you must use dynamic SQL. If you search the
.programming newsgroup, you will find lots of information and links
regarding the use of dynamic sql. Also, nested if/else logic will work
if the set of tables that might possibly be used is known.
4. Migration from Informix (7.13) to Adaptive Server Enterprise (Sybase SQL Server 11.5) -- Question !!
6. This made me go hmmmm on Unidata.
9. Parametric sub-queries (Access Views) in SQL Server 7
10. Parametric Tables in Transact - SQL
11. How to create a parametric View in SQL server 2000
12. parametric search engine for msaccess' 97
13. Bound controls and parametric command with DataEnvironment