SELECT INTO We can do it using SELECT INTO clause. Syntax: SELECT <Columns List> INTO <New Table Name> FROM <Existing Table Name> Ex: SELECT * INTO dbo.EmployeeBKP FROM dbo.Employee When you execute the above query, dbo.EmployeeBKP table will be created automatically with the

Read More