how to copy data to a table from another database table

Question

Suthish Nair · Answer

Abdu why you creating so much duplicate threads?

Soft Corner · Answer

Hi  Try this SELECT * INTO Database1.dbo. NewTableName FROM Database2 .dbo.OldTable