INSERT TABLE OF CONTENT OF ONE TABLE OF ONE DATABASE INTO ANOTHER TABLE OF ANOTHER DATABASE WHERE THE DESTINATION TABLE WILL BE AUTOMATICALLY CREATED

SELECT * INTO (DESTINATION) DATABASENAME.SCHEMANAME.TABLENAME FROM (SOURCE) DATABASENAME.SCHEMANAME.TABLENAME

EXAMPLE-SELECT * INTO EMP1.DBO.EMPLOYEE FROM EMP2.DBO.EMPLOYEE