copy table content from one db to another db

Copy Table Content from one DB to another DB.

----------------------------------------------------------------------------------------------------------------------

SELECT * INTO targetdbname..tablename FROM sourcedb..tablename
Using the above command you can copy the table content from one SQL DB to Another SQL DB 

----------------------------------------------------------------------------------------------------------------------
INSERT INTO tablename(field1,field2) SELECT field1,field2 FROM tablename

Using the above command you can copy the table content from one table to Another table