If you are reading this then you probably want to create a table in SQL server using the Create Table As statement. Essentially you want to create the a new table based on one or more tables.
Here is how you do that. Instead of issuing a CREATE TABLE AS . . .” statement, you simply put an “into TABLE_NAME” before the from statement in your SQL statement. See the examples below.
If you had two tables that were alike and you wanted to create a new table containing the values found in both tables, then you would write the following query.