Copy Full data from one table to another in SQL Server database

In  this article i have explained the way to copy data from one table to another in the same database.

Suppose we have Employee table having some data and we want to copy entire structure and data from Employee table to another table e.g EmployeeCopy  then the query will be:

select * into EmployeeCopy  from Employee


Note: This query will create  EmployeeCopy  table  having all the data copied from the Employee  table.