Another easy one just jotting down to remember
insert into NEW_SERVER.NEW_DATABASE.dbo.NEW_TABLE select * from SERVER.DATABASE.dbo.TABLE
