Copy data from One table particular data to another database table

Question

I want to copy some fileds of a table data to another database table how? Here not copy a full of table data...

Satyapriya Nayak · Answer

Hi Abdu select columnname into newtable from oldtable Ex: SELECT empname INTO employee1 FROM employee Thanks

Sam Hobbs · Answer

This question has been asked before. I don't remember the answer. You can use SQL Server tools to do things like that. If you must do it in a program then tehre have been answers in previous threads.

Pravin More · Answer

please provide structure of sorce and target table.