Making BackUp Table With Data or Without Data by using SqlQuery

This query will create a table with Name Employee2 with all data and same structure of Employee table, here only those column and column data  will copy which I mention in Select command

SELECT name,Country, Mobile,Salary INTO Employee2 FROM Employee

This query will create a table with name Employee 3 by having the same structure of Employee table this query will not copy data

SELECT * INTO Employee3 FROM Employee WHERE 1=2

If we write this query as 

SELECT * INTO Employee3 FROM Employee

then it will also copy all data. 

Ebook Download
View all
Learn
View all