Copy whole table to another database
you can create a table with same schema in another database first and copy the data like this. Let say my new Database name is NewDataBase and I want to copy data from table Sales.SalesPerson of [AdventureWorks2012] database and both database are in same server.


CREATE TABLE [NewDataBase].[dbo].EmployeeSales
( BusinessEntityID   varchar(11) NOT NULL,
  SalesYTD money NOT NULL
);
GO

INSERT INTO [NewDataBase].[dbo].EmployeeSales
    SELECT BusinessEntityID, SalesYTD 
    FROM [AdventureWorks2012].Sales.SalesPerson;
GO