>Hi all,
> On SQL Server, I have table1 and table2. I want to copy a whole column on table1 into a column of table2. Table1 is not empty, it got data but table2 is empty. How to do that? Please, help me!
> Thank you.

In Oracle, I can do this with a single SQL command:

insert into table2 (column_name) (select column_name from table1)