SQL: How to Insert INTO values from another table into another table

If you want to insert into a table value from another table or from CTE, make sure that you define columns to insert into a table then select * from cte/table. If you want to select into NEWTABLE from another table, there is no need to define columns to insert into.


Yes Was this page helpful? No
Yes Was this page helpful? No