Insert INTO

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.

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
Login to Continue

Community of Software Developers

Welcome, log in to continue reading. It's free and only takes a minute.




© 2020 - ErnesTech - Privacy