How to copy data from one table to another table in sql server

Syntax:- select * into NewTableName from ExistingTableName


Example:- select * into employee1 from employee


Note: where employee is the existing table. this query create a new table (employee1) and copy all the data of employee table in newly created table


        I hope this will help you!!