Which of the following queries is used to copy data present in employees table into another non existing table ( which is not present in database ) ?
select * into new_table_name from existing_tablename
It is not possible to copy data from a table into another table which is not existing before executing the current query
insert into new_table_name select * from existing_table_name
insert into new_table_name values select * from existing_table_name
T-SQL will allow copying data from an existing table into a non-existing-table .
Ex: the below query will create a table called ABC in the current database ( whose structure is same as employees table ) and copies data from employees table into ABC table .
select * into ABC from employees ;
Back To Top