Copy data from one table to another

Copy Data from one table to another when Database is different,

Here is simple query for this :

INSERT INTO dbo. NewTable(FieldName)

SELECT FieldName FROM existingdb.dbo.existingtable;

SELECT * INTO  NewTable  FROM  existingdb.dbo.existingtable;