INSERT TABLE OF CONTENT OF ONE TABLE OF ONE DATABASE INTO ANOTHER TABLE OF ANOTHER DATABASE

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

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