What is SQL “SELECT INTO”? And when you Use “SELECT INTO”?
In this Article, I going to share the detail about SQL Server “SELECT INTO” Statement and detail as following as.
SQL SELECT INTO is use to “SELECT” data from one table and “INSERT” into a new table and also creates a new table located in the default filegroup. It is copied all columns records with same data types also.
It is only “INSERT” the values of existing tables “INTO” a new table.
SQL SELECT INTO statement can also use to “Copy” data from more than one table into a new table that means you can use “SQL JOINS” to “SELECT” records from multiple tables and “INSERT” in a single table.
SQL SELECT INTO statement can also use to CREATE a “new”, “empty” table using another table schema. You can just add a “WHERE” clause that is return no records (empty rows).
Stayed Informed - Create Country Table & Insert 192 Countries Data!
The “New Table” must not exist in the querying database. If it already exists, the SELECT INTO statement will throw an error.
According to Microsoft docs, “The FILESTREAM attribute does not transfer when you create a new table by using the SELECT INTO statement. FILESTREAM BLOBs are copied and stored in the new table as varbinary (max) BLOBs. If a FILESTREAM BLOB exceeds 2 GB, the following error message is raised and the statement is stopped: "Attempting to grow LOB beyond maximum allowed size of 2147483647 bytes.””
The Query 1 result and Query 3 result are same that means copies all the data from an existing “COUNTRIES” table INTO “COUNTRIESCOPY” new table.
Stayed Informed – Best SQL Server Tutorials, Examples and QA also!
I hope you are enjoying with this post! Please share with you friends. Thank you!!