What is SELECT into statement in SQL?

What is SELECT into in SQL?

The SELECT INTO command copies data from one table and inserts it into a new table. The following SQL statement creates a backup copy of Customers: SELECT * INTO CustomersBackup2017.

What is the use of SELECT into?

Introduction to SQL Server SELECT INTO statement The SELECT INTO statement creates a new table and inserts rows from the query into it. If you want to copy the partial data from the source table, you use the WHERE clause to specify which rows to copy.

What is the difference between SELECT and SELECT into?

Differences. INSERT INTO SELECT inserts into an existing table. SELECT INTO creates a new table and puts the data in it.

What is SELECT into existing table?

The INSERT INTO SELECT statement copies data from one table and inserts it into another table. The INSERT INTO SELECT statement requires that the data types in source and target tables match. Note: The existing records in the target table are unaffected.