If you want copy data from one database to another on the same server you could use next SQL:

INSERT INTO [DestinationDatabase].[dbo].[Table1] ([Column1], [Column2], [Column3])
    SELECT [Column1], [Column2], [Column3] FROM [SourceDatabase].[dbo].[Table2]

Also if you want to copy data with the schema of table, i.e. copy table structure and contents to another database you could use:

SELECT * INTO [DestinationDatabase].[dbo].[TABLE]
   FROM [SourceDatabase].[dbo].[TABLE]

If you haven't subsribed yet, you can subsribe below: