silicongelica
Programmer
Table2 contains no real data, but has been created with the column names that are the list of columns that I want to select in a query for Table1. How do I write that into a query?
I found sp_columns, and that nicely spits out the column info for Table2, but I need to find a way to query the information schema and write that right into the query....
Select ((Table2 List of columns))
from Table1
Can anyone help me figure this out?
I found sp_columns, and that nicely spits out the column info for Table2, but I need to find a way to query the information schema and write that right into the query....
Select ((Table2 List of columns))
from Table1
Can anyone help me figure this out?