Copy Full data of Table of one database to Table of Different database in SQL Server

In this article i have explained the way to copy all the data one database table to another database table. Suppose we have "Employee" table in the database "FirstDataBase" having some data and we want to copy entire structure and data into another table "Employee" of another database "SecondDataBase" then the query will be as:


select * into SecondDataBase.dbo.Employee from FirstDataBase.dbo.Employee

Note: This query will create  Employee table in SecondDataBase  having all the data copied from the Employee  table of FirstDataBase.