Hi,
Is there a way to insert data into a table (via a select statement) without specifying column names ?
I'm trying to do something like:
insert into allCustomer
select
1 as LogID ,
'C' as ChangeType ,
getdate() as TransactionDate,
*
from customer
All of the column names/types match the target table "allCustomer" but I wanted to avoid specifying them all as the table has over 100 columns.
Is there a way to insert data into a table (via a select statement) without specifying column names ?
I'm trying to do something like:
insert into allCustomer
select
1 as LogID ,
'C' as ChangeType ,
getdate() as TransactionDate,
*
from customer
All of the column names/types match the target table "allCustomer" but I wanted to avoid specifying them all as the table has over 100 columns.